shopping

Tables (7)

Category (Untitled2)

  • CATEGORY_ID (Key) — Long — Primary key — NOT NULL
  • name (Field) — String

Category_ITEM (Untitled3)

  • CATEGORY_ID (Key) — Long — Foreign key → Category.CATEGORY_ID — NOT NULL
  • ITEM_ID (Key2) — Foreign key → ITEM.ITEM_ID — NOT NULL

ITEM (Untitled4)

  • ITEM_ID (Key) — Primary key — NOT NULL
  • name (Field) — String
  • price (Field2) — int
  • stockquantity (Field3) — int
  • DTYPE (Field4)
  • ARTIST (Field5)
  • ETC (Field6)
  • AUTHOR (Field7)
  • ISBN (Field8)
  • DIRECTOR (Field9)
  • ACTOR (Field10)

Member (회원)

  • MEMBER_ID (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • city (Field2) — String
  • street (Field3) — String
  • zipcode (Field4) — String

OrderItem (Untitled)

  • ORDER_ITEM_ID (Key) — Long — Primary key — NOT NULL
  • orderPrice (Field) — int
  • count (Field2) — int
  • ORDER_ID (Key2) — Long — Foreign key → orders.ORDER_ID — NOT NULL
  • ITEM_ID (Key3) — Foreign key → ITEM.ITEM_ID — NOT NULL

delivery (배송)

  • DELIVER_ID (Key) — Long — Primary key — NOT NULL
  • status (Field) — String
  • city (Field2) — String
  • street (Field3) — String
  • zipcode (Field4) — String
  • ORDER_ID (Key2) — Long — Foreign key → orders.ORDER_ID — NOT NULL

orders (주문)

  • ORDER_ID (Key) — Long — Primary key — NOT NULL
  • orderDate (Field) — Date
  • status (Field2) — String
  • MEMBER_ID (Key2) — Long — Foreign key → Member.MEMBER_ID — NOT NULL