쇼핑
테이블 (6)
CART (Untitled3)
- ID (Key) — NOTNULL — 기본 키 — NOT NULL
- CREATE_TIME (Field3) — NOTNULL
- STATUS (Field) — NOTNULL
- PRODUCT_NUM (Field2) — NOTNULL
- USER_ID (Key2) — NOTNULL — 외래 키 → USER.ID — NOT NULL
ORDER (Untitled2)
- ORDER_ID (Key) — NOTNULL — 기본 키 — NOT NULL
- ORDER_TIME (Field8) — NOTNULL
- PRODUCT_NUM (Field) — NOTNULL
- ORDER_COMPLETE (Field2) — NULLABLE
- CREATE_DATE (Field4) — NOTNULL
- PAYMENT_COMPLETE_DATE (Field3) — NULLABLE
- AMOUNT (Field5) — NOTNULL
- STATUS (Field6) — NOTNULL
- USER_ID (Key2) — NOTNULL — 외래 키 → USER.ID — NOT NULL
- PRODUCTS (Field7) — NOTNULL
ORDERDETAIL (Untitled5)
- ID (Key) — NOTNULL — 기본 키 — NOT NULL
- PRODUCTNUM (Field) — NOTNULL
- ORDER_ID (Key2) — NOTNULL — 외래 키 → ORDER.ORDER_ID — NOT NULL
- PRODUCT_ID (Key3) — NOTNULL — 외래 키 → PRODUCT.ID — NOT NULL
PRODUCT (Untitled)
- ID (Key) — NOTNULL — 기본 키 — NOT NULL
- TITLE (Field) — NOTNULL
- CONTENT (Field2) — NOTNULL
- NAME (Field3) — NOTNULL
- PRICE (Field4) — NOTNULL
- TOTAL (Field5) — NOTNULL
- IMAGE_URL (Field6) — NOTNULL
- CREATE_DATE (Field9) — NOTNULL
- MODIFIED_DATE (Field7) — NOTNULL
- STATUS (Field8) — NOTNULL
- USER_ID (Key2) — NOTNULL — 외래 키 → USER.ID — NOT NULL
- CART_ID (Key4) — NOTNULL — 외래 키 → CART.ID — NOT NULL
REVIEW (Untitled4)
- ID (Key) — NOTNULL — 기본 키 — NOT NULL
- TITLE (Field) — NOTNULL
- CONTENT (Field2) — NOTNULL
- IMAGE_URL (Field3) — NULLABLE
- CREATE_TIME (Field4) — NOTNULL
- MODIFIED_TIME (Field5) — NOTNULL
- STATUS (Field6) — NOTNULL
- USER_ID (Key2) — NOTNULL — 외래 키 → USER.ID — NOT NULL
- PRODUCT_ID (Key3) — NOTNULL — 외래 키 → PRODUCT.ID — NOT NULL
USER (.)
- ID (Key) — NOTNULL — 기본 키 — NOT NULL
- USERNAME (Field) — NOTNULL
- ADDRESS (Field2) — NOTNULL
- AGE (Field3) — NOTNULL
- NICKNAME (Field4) — NOTNULL
- PHONENUMBER (Field5) — NOTNULL
- CREATE_DATE (Field6) — NOTNULL
- MODIFIED_DATE (Field7) — NOTNULL
- POSTCODE (Field8) — NOTNULL
- STATUS (Field9) — NOTNULL
- ROLES (Field10) — NOTNULL
- PASSWORD (Field11) — NOTNULL
- EMAIL (Field12) — NOTNULL