MasilCoffeeSchemas
Tables (6)
Board (Untitled5)
- BoardId (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- title (Field2) — String
- post (Field) — String
- image (Field3) — String
Comment (Untitled6)
- CommentId (Key) — Primary key — NOT NULL
- BoardId (Key2) — Foreign key → Board.BoardId — NOT NULL
- user_id (Key22) — Foreign key → Board.user_id — NOT NULL
- comment (Field) — String
Order (Untitled3)
- _id (Key) — Primary key — NOT NULL
- user_id (Key4) — Foreign key → User.user_id — NOT NULL
- detailorder_id (Key3) — Foreign key → Order_detail.detailorder_id — NOT NULL
- totalprice (Field) — Number
- status (Field2) — enum["주문취소",, "주문완료", "제조완료"]
- _id (Key2) — Foreign key → Product._id — NOT NULL
Order_detail (Untitled4)
- detailorder_id (Key) — Primary key — NOT NULL
- shot (Field) — Number
- drizzle (Field2) — String
- iceAmount (Field3) — enum["조금", "보통", "많이"]
- whipping (Field4) — enum["조금", "보통", "많이"]
- syrup (Field5) — String
- milk (Field6) — String
Product (Untitled2)
- _id (Key) — Primary key — NOT NULL
- name (Field) — String
- image (Field2) — String
- category (Field3) — enum["Espresso", "NonCoffee", "Smoothie", "Tea", "Ade", "Side Menu"]
- size (Field4) — enum["Tall", "Large"]
- temp (Field5) — enum["Ice","Hot"]
- info (Field6) — String
- kcal (Field7) — Number
User (Untitled)
- user_id (Key) — Primary key — NOT NULL
- name (Field2) — String
- nickname (Field3) — String
- password (Field4)
- role (Field5) — enum["User","Admin"]
- email (Field6) — String
- phoneNumber (Field7) — String