Cafe
Tables (4)
Drink (Untitled2)
- drink_id (Key) — int — Primary key — NOT NULL
- drink (Field) — varchar(100)
- drink_content (Field2) — varchar(500)
- drink_price (Field3) — int
Receipt (Untitled3)
- receipt_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
- receipt_date (Field2) — date
- receipt_finish (Field3) — date
- receipt_state (Field) — int
- totalprice (Field4) — int
User (Untitled)
- user_id (Key) — int — Primary key — NOT NULL
- id (Key2) — varchar(100) — NOT NULL
- pw (Field) — varchar(100)
- user_name (Field2) — varchar(100)
- user_hp (Field3) — varchar(50)
userOrder (Untitled4)
- userOrder_id (Key) — int — Primary key — NOT NULL
- receipt_id (Key3) — int — Foreign key → Receipt.receipt_id — NOT NULL
- drink_id (Key2) — int — Foreign key → Drink.drink_id — NOT NULL
- user_id (Key22) — int — Foreign key → Receipt.user_id — NOT NULL
- cnt (Field)