juan

Tables (4)

Type (세대타입)

  • id (pk) — Long — Primary key — NOT NULL
  • Field

apartment (아파트단지)

  • id (pk) — Long — Primary key — NOT NULL
  • name (단지명) — Char

calculation (산출)

  • id (pk) — Long — Primary key — NOT NULL
  • type (세대타입) — Long — Foreign key → Type.id — NOT NULL
  • work (작업종류) — char
  • room (방) — char
  • point (작업위치) — char
  • content (수식) — char
  • value (값) — long

house (세대)

  • id (pk) — Long — Primary key — NOT NULL
  • apartment (아파트단지) — Long — Foreign key → apartment.id — NOT NULL
  • type (세대타입) — Long — Foreign key → Type.id — NOT NULL
  • building (동) — Integer
  • unit (호) — Integer