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