Convenience_Store - 2022-04-14 14:25:56

Tables (4)

Branch (stores_branch)

  • Key — Primary key — NOT NULL
  • 상세주소 (village_id) — Foreign key → Village.Key — NOT NULL
  • 지역 (local_id) — Foreign key → Village.지역 — NOT NULL
  • 지점 (num) — int

Keep (stores_keep)

  • Key — Primary key — NOT NULL
  • 지점 (branch_id) — Foreign key → Branch.Key — NOT NULL
  • 상세주소 (village_id) — Foreign key → Branch.상세주소 — NOT NULL
  • 지역 (local_id) — Foreign key → Branch.지역 — NOT NULL
  • 입고시각 (receive_time) — datetimefield
  • 보관방법 (keep_method) — varchar(20)

Local (stores_local)

  • Key — Primary key — NOT NULL
  • 도시 (city) — varchar(20)

Village (stores_village)

  • Key — Primary key — NOT NULL
  • 지역 (local_id) — Foreign key → Local.Key — NOT NULL
  • 동 (town) — varchar(20)
  • 인구 (people) — int