ssense

Tables (7)

Images (사진)

  • item_id (Key) — long — Foreign key → Item.item_id — NOT NULL

Item (상품)

  • item_id (Key) — long — Primary key — NOT NULL
  • item_name (이름) — str
  • price (가격) — int
  • category (분류)
  • designer (디자이너) — str
  • stock (재고) — int

Mapped (Untitled)

  • created_date (생성일) — localDateTime
  • views (조회수) — long

Member (회원)

  • member_id (Key) — long — Primary key — NOT NULL
  • username (아이디) — str
  • password (비밀번호) — str
  • role (권한) — role
  • first_name (이름) — str
  • last_name (성) — str
  • address (주소) — address

Order (주문)

  • order_id (Key) — long — Primary key — NOT NULL
  • member_id (Key2) — long — Foreign key → Member.member_id — NOT NULL
  • status (상태) — orderstatus
  • order_date (주문일시) — localDateTime

OrderItem (주문한 상품)

  • item_id (Key) — long — Foreign key → Item.item_id — NOT NULL
  • order_id (Key2) — long — Foreign key → Order.order_id — NOT NULL
  • order_price (주문 당시 가격) — int
  • count (수량) — int

Sale (할인)

  • item_id (Key) — long — Foreign key → Item.item_id — NOT NULL
  • period (세일 기간) — period
  • rate (할인율) — float