coffee app

Tables (3)

Coffee (Untitled)

  • COFFEE_ID (CoffeeId) — INT — Primary key — NOT NULL
  • KORNAME (KorName) — VARCHAR(100)
  • ENGNAME (EngName) — VARCHAR(100)
  • PRICE (Price) — VARCHAR(100)
  • COFFEECODE (CoffeeCode) — VARCHAR(100)
  • COFFEESTATUS (CoffeeStatus) — VARCHAR(100)
  • CREATEDAT (CreatedAt) — DATE
  • MODIFIEDAT (ModifiedAt) — DATE

Member (Untitled2)

  • MEMBER_ID (MemberId) — INT — Primary key — NOT NULL
  • EMAIL (Email) — VARCHAR(100)
  • NAME (Name) — VARCHAR(100)
  • PHONE (Phone) — VARCHAR(100)
  • MEMBERSTATUS (MemberStatus) — VARCHAR(100)
  • CREATEDAT (CreatedAt) — DATE
  • MODIFIEDAT (ModifiedAt) — DATE

Order (Untitled3)

  • ORDER_ID (orderId) — INT — Primary key — NOT NULL
  • ORDERSTATUS (orderStatus) — VARCHAR(100)
  • CREATEDAT (createdAt) — DATE
  • MODIFIEDAT (modifiedAt) — DATE
  • ORDERS (orders)