be-study

Tables (4)

Member (Untitled)

  • member_id (Key) — long — Primary key — NOT NULL
  • loginId (Field) — varchar(50)
  • password (Field2) — varchar(50)
  • phoneNumber (Field3) — varchar(50)
  • adress (Field4) — varchar(50)
  • point (Field5) — int
  • Field6 — ㅗㅑ
  • Field7

Order (Untitled2)

  • order_id (d) — long — Primary key — NOT NULL
  • Field

OrderProduct (Untitled4)

  • order_id (d) — long — Foreign key → Order.order_id — NOT NULL
  • product_id (Key) — long — Foreign key → Product.product_id — NOT NULL
  • Field

Product (Untitled3)

  • product_id (Key) — long — Primary key — NOT NULL
  • Field