CREATE TABLE [NETWORK] 
(
    [ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    [CR_DATE] TEXT,
    [ID_AUTHOR] TEXT,
    [COMMENT] TEXT
)

CREATE TABLE [NET_CONFIG] 
(
    [ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    [CR_DATE] DATE,
    [AUTHOR] TEXT,
    [INFO] TEXT,
    [ENABLED] BOOLEAN
)

CREATE TABLE [NETWORK_HAS_NET_CONFIG] 
(
    [ID_NETWORK] INTEGER NOT NULL REFERENCES [NETWORK]
    (
        ID
    ),
    [ID_NCONFIG] INTEGER NOT NULL REFERENCES [NET_CONFIG]
    (
        ID
    ),
    PRIMARY KEY 
    (
        [ID_NCONFIG],
        [ID_NETWORK]
    )
)

INSERT INTO NETWORK (CR_DATE, ID_AUTHOR, COMMENT) VALUES ('22.07.2010', 'prophet', 'Hoi');
INSERT INTO NETWORK (CR_DATE, ID_AUTHOR, COMMENT) VALUES ('22.07.2010', 'prophet', 'PisPis');
INSERT INTO NETWORK (CR_DATE, ID_AUTHOR, COMMENT) VALUES ('22.07.2010', 'prophet', 'Oppa');

INSERT INTO NET_CONFIG (CR_DATE, AUTHOR, INFO) VALUES ('11.06.2010', 'Author', 'dsfd', '');
INSERT INTO NET_CONFIG (CR_DATE, AUTHOR, INFO) VALUES ('23.07.2010', 'Author', 'hgfhfg', '');
INSERT INTO NET_CONFIG (CR_DATE, AUTHOR, INFO) VALUES ('23.07.2010', 'prophet', 'dsfsdf', '');

Связи:

INSERT INTO NETWORK_HAS_NET_CONFIG (ID_NETWORK, ID_NCONFIG) VALUES ( 1 ,  1 );
INSERT INTO NETWORK_HAS_NET_CONFIG (ID_NETWORK, ID_NCONFIG) VALUES ( 2 ,  2 );
INSERT INTO NETWORK_HAS_NET_CONFIG (ID_NETWORK, ID_NCONFIG) VALUES ( 1 ,  3 );

SELECT ID,CR_DATE,AUTHOR FROM NET_CONFIG WHERE ID = (SELECT ID_NCONFIG FROM NETWORK_HAS_NET_CONFIG WHERE ID_NETWORK = '1')

SELECT ID,CR_DATE,AUTHOR FROM NET_CONFIG WHERE '9' IN (SELECT ID_NETWORK FROM NETWORK_HAS_NET_CONFIG WHERE NET_CONFIG.ID = NETWORK_HAS_NET_CONFIG.ID_NCONFIG)

UPDATE NET_CONFIG SET ENABLED= 0  WHERE ID=(SELECT conf.ID 
FROM NET_CONFIG conf JOIN NETWORK_HAS_NET_CONFIG has ON has.ID_NCONFIG=conf.ID AND has.ID_NETWORK= 1 )

CREATE TABLE [RMATRIX] 
(
    [ID_DEV_A] INTEGER NOT NULL REFERENCES [DEVICES](ID),
    [ID_DEV_B] INTEGER NOT NULL REFERENCES [DEVICES](ID),
    [ID_NETWORK] INTEGER NOT NULL REFERENCES [NETWORK](ID),
    [FLAGS] INTEGER,  
    PRIMARY KEY ([ID_DEV_B], [ID_DEV_A])
)

CREATE TABLE [DEVICES] 
(
    [ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    [ID_TYPE] INTEGER NOT NULL REFERENCES [DEV_TYPES](ID),
    [LOCATION] TEXT,
    [DESCRIBE] TEXT,
    [ENABLED] BOOLEAN
)

SELECT DESCRIBE FROM DEVICES WHERE ID IN
(SELECT ID_DEV_B FROM RMATRIX WHERE ID_DEV_A =
(SELECT ID FROM DEVICES WHERE DESCRIBE = 'N1-D1') UNION
SELECT ID_DEV_A FROM RMATRIX WHERE ID_DEV_B =
(SELECT ID FROM DEVICES WHERE DESCRIBE = 'N1-D1'))