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)