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