BE-1
Tables (5)
Cafe
- Key (cafe_id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(50)
Menu
- Key (menu_id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(50)
- 가격 (price) — INT
- Key (cafe_id) — BIGINT — Foreign key → Cafe.Key — NOT NULL
Menu_Record
- Key (menu_record_id) — BIGINT — Primary key — NOT NULL
- 개수 (count) — INT
- Key (record_id) — BIGINT — Foreign key → Record.Key — NOT NULL
- Key (menu_id) — BIGINT — Foreign key → Menu.Key — NOT NULL
Person
- Key (person_id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(50)
- 돈 (money) — BIGINT
Record
- Key (record_id) — BIGINT — Primary key — NOT NULL
- 날짜 (date) — DATETIME
- Key (person_id) — BIGINT — Foreign key → Person.Key — NOT NULL
- Key (cafe_id) — BIGINT — Foreign key → Cafe.Key — NOT NULL