쇼핑몰(갠플)

테이블 (5)

cart (Untitled)

  • cart_id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Field) — varchar
  • product_id (Field2) — bigint
  • quantity (Field3) — int

category (categories)

  • category_id (Key) — bigint — 기본 키 — NOT NULL
  • category_name (Field) — varchar
  • product_id (FK: products) — bigint

order (orders)

  • order_id (Key) — bigint — 기본 키 — NOT NULL
  • uesr_id (FK: users) — varchar
  • total_price (Field) — int
  • order_status (Field2)
  • crt_dtm (Field3) — timestamp

product (products)

  • product_id (Key) — bigint — 기본 키 — NOT NULL
  • product_name (Field) — varchar
  • description (Field2) — text
  • price (Field3) — int
  • category_id (Field4) — bigint
  • crt_dtm (Field5) — timestamp
  • mdf_dtm (Field6) — timestamp

user

  • uesr_id (Key) — varchar — 기본 키 — NOT NULL
  • uesr_name (Field) — varchar
  • user_type (Field2) — varchar
  • user_pwd (Field3)
  • crt_dtm (Field4) — timestamp
  • mdf_dtm (Field5) — timestamp
  • user_email (Field6) — varchar
  • user_phone (Field7) — varchar
  • user_nickname (Field8) — varchar