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