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)