Iprlab
Tables (27)
address (address_db)
- adr_id (Key) — Primary key — NOT NULL
all (index_db)
- id (Key) — Primary key — NOT NULL
building (building_db)
- id1 (Key) — Primary key — NOT NULL
- id2 (Key2) — Primary key — NOT NULL
- id3 (Key3) — Primary key — NOT NULL
- pnu (Key4) — Foreign key → land_pnu.pnu — NOT NULL
corp (corp_db)
- corp_id (Key2) — Primary key — NOT NULL
- address (Field2)
- dart_id (Key) — NOT NULL
deal (deal_db)
- deal_id (Key4) — Primary key — NOT NULL
- id1 (Key) — Foreign key → building.id1 — NOT NULL
- id2 (Key2) — Foreign key → building.id2 — NOT NULL
- id3 (Key3) — Foreign key → building.id3 — NOT NULL
- corp_id (Field)
infra_1 (infra_db)
- infra_id (Key) — Primary key — NOT NULL
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
infra_10 (CopyOfinfra_db7)
- infra_id (Key) — Primary key — NOT NULL
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
infra_2 (CopyOfinfra_db)
- infra_id (Key) — Primary key — NOT NULL
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
infra_3 (infra_db2=)
- infra_id (Key) — Primary key — NOT NULL
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
infra_4 (infra_db2)
- infra_id (Key) — Primary key — NOT NULL
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
infra_5 (CopyOfinfra_db2)
- infra_id (Key) — Primary key — NOT NULL
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
infra_6 (CopyOfinfra_db3)
- infra_id (Key) — Primary key — NOT NULL
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
infra_7 (CopyOfinfra_db4)
- infra_id (Key) — Primary key — NOT NULL
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
infra_8 (CopyOfinfra_db5)
- infra_id (Key) — Primary key — NOT NULL
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
infra_9 (CopyOfinfra_db6)
- infra_id (Key) — Primary key — NOT NULL
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
land_1 (land_db)
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
land_2 (asd)
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
land_3 (CopyOfland_db2)
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
land_4 (land_Db)
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
land_5 (CopyOfland_db3)
- pnu (Key2) — Foreign key → land_pnu.pnu — NOT NULL
land_pnu (CopyOfland_db)
- pnu (Key) — Primary key — NOT NULL
lease (lease_db)
- lease_id (Key4) — Primary key — NOT NULL
- id1 (Key) — Foreign key → building.id1 — NOT NULL
- id2 (Key2) — Foreign key → building.id2 — NOT NULL
- id3 (Key3) — Foreign key → building.id3 — NOT NULL
- corp_id (Field)
- rent_id (Field2)
lssues (issue_db)
- id (Key) — Primary key — NOT NULL
property (owner_db)
- id1 (Key) — Foreign key → building.id1 — NOT NULL
- id2 (Key2) — Foreign key → building.id2 — NOT NULL
- id3 (Key3) — Foreign key → building.id3 — NOT NULL
- pnu (Key4) — Foreign key → building.pnu — NOT NULL
- corp_id (Key22) — Foreign key → corp.corp_id — NOT NULL
resident_1 (resident_db)
- id (Key) — Primary key — NOT NULL
- adr_id (Key2) — Foreign key → address.adr_id — NOT NULL
resident_2 (CopyOfresident_db)
- id (Key) — Primary key — NOT NULL
- adr_id (Key2) — Foreign key → address.adr_id — NOT NULL
resident_3 (resident_db2)
- id (Key) — Primary key — NOT NULL
- adr_id (Key2) — Foreign key → address.adr_id — NOT NULL