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