쇼핑

테이블 (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