prac1

테이블 (15)

ALBUM (Untitled9)

  • ITEM_ID (Key) — 외래 키 → ITEM.ITEM_ID — NOT NULL
  • ARTIST (Field)

ALBUM (Untitled13)

  • ITEM_ID (Key) — 기본 키 — NOT NULL
  • NAME (Field)
  • PRICE (Field2)
  • ARTIST (Field3)

BOOK (Untitled11)

  • ITEM_ID (Key) — 외래 키 → ITEM.ITEM_ID — NOT NULL
  • AUTHOR (Field)
  • ISBN (Field2)

BOOK (Untitled15)

  • ITEM_ID (Key) — 기본 키 — NOT NULL
  • NAME (Field)
  • PRICE (Field2)
  • AUTHOR (Field3)
  • ISBN (Field4)

ITEM (Untitled8)

  • ITEM_ID (Key) — 기본 키 — NOT NULL
  • NAME (Field)
  • PRICE (Field2)
  • DTYPE (Field3)

ITEM (Untitled12)

  • ITEM_ID (Key) — 기본 키 — NOT NULL
  • NAME (Field)
  • PRICE (Field2)
  • DTYPE (Field3)
  • ARTIST (Field4) — Nullable
  • DIRECTOR (Field5) — Nullable
  • ACTOR (Field6) — Nullable
  • AUTHOR (Field7) — Nullable
  • ISBN (Field8) — Nullable

MOVIE (Untitled10)

  • ITEM_ID (Key) — 외래 키 → ITEM.ITEM_ID — NOT NULL
  • DIRECTOR (Field)
  • ACTOR (Field2)

MOVIE (Untitled14)

  • ITEM_ID (Key) — 기본 키 — NOT NULL
  • NAME (Field)
  • PRICE (Field2)
  • DIRECTOR (Field3)
  • ACTOR (Field4)

배송 (Untitled5)

  • id (Key) — 기본 키 — NOT NULL
  • city (Field)
  • street (Field2)
  • zipcode (Field3)
  • status (Field4)
  • created_date (Field5)
  • last_modified_date (Field6)

상품 (Untitled2)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • price (Field2)
  • stock_quantity (Field3)
  • dtype (Field4)
  • artist (Field5)
  • director (Field6)
  • actor (Field7)
  • author (Field8)
  • isbn (Field9)
  • created_date (Field10)
  • last_modified_date (Field11)

주문 (Untitled3)

  • id (Key2) — 기본 키 — NOT NULL
  • order_date (Field)
  • status (Field2)
  • user_id (Key) — 외래 키 → 회원.id — NOT NULL
  • delivery_id (Key3) — 외래 키 → 배송.id — NOT NULL
  • created_date (Field3)
  • last_modified_date (Field4)

주문_상품 (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • order_price (Field)
  • count (Field2)
  • order_id (Key2) — 외래 키 → 주문.id — NOT NULL
  • item_id (Key3) — 외래 키 → 상품.id — NOT NULL
  • created_date (Field3)
  • last_modified_date (Field4)

카테고리 (Untitled6)

  • id (Key) — 기본 키 — NOT NULL
  • parent_id (Key2) — 외래 키 → 카테고리.id — NOT NULL
  • name (Field)
  • created_date (Field2)
  • last_modified_date (Field3)

카테고리_상품 (Untitled7)

  • category_id (Key) — 외래 키 → 카테고리.id — NOT NULL
  • item_id (Key2) — 외래 키 → 상품.id — NOT NULL
  • created_date (Field)
  • last_modified_date (Field2)

회원 (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • city (Field2)
  • street (Field3)
  • zipcode (Field4)
  • created_date (Field5)
  • last_modified_date (Field6)