Namhung

Tables (5)

Bird_eye

  • Bird_UID — int — Primary key — NOT NULL
  • src — char(200)
  • B_UID — int — Foreign key → Building.B_UID — NOT NULL

Building

  • B_UID — int — Primary key — NOT NULL
  • Status — Char(50)
  • Process — int
  • Name — Char(100)
  • Outline — Char(200)

FieldPhoto

  • Field_UID — int — Primary key — NOT NULL
  • Date — char(50)
  • B_UID — int — Foreign key → Building.B_UID — NOT NULL

FieldPhoto_Detail

  • Detail_UID — int — Primary key — NOT NULL
  • src — char(200)
  • Field_UID — int — Foreign key → FieldPhoto.Field_UID — NOT NULL

FloorPlan

  • Floor_UID — int — Primary key — NOT NULL
  • src — char(200)
  • B_UID — int — Foreign key → Building.B_UID — NOT NULL