쇼핑몰(갠플)
테이블 (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