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)