Webshop
Tables (4)
Cart (장바구니)
- C_ID (Key) — PK — Primary key — NOT NULL
- U_ID (U_REF) — PK — Foreign key → User.U_ID — NOT NULL
- P_ID (P_REF) — PK — Foreign key → Product.P_ID — NOT NULL
- Qty (수량) — Number
- Price (가격(수량에 맞는 가격)) — Number
- Order Complete (주문완료 여부) — Yes or No
Orders List (주문목록)
- 주문번호 (Key) — PK — Primary key — NOT NULL
- C_ID (C_REF) — PK — Foreign key → Cart.C_ID — NOT NULL
- U_ID (U_REF) — PK — Foreign key → Cart.U_ID — NOT NULL
- P_ID (P_REF) — PK — Foreign key → Cart.P_ID — NOT NULL
Product (제품)
- P_ID (Key) — PK — Primary key — NOT NULL
- Name (제품명) — Text
- Description (제품설명) — Text
- Image link (제품 이미지 링크) — Text
- Price (제품 가격) — Number
- Product Category (제품 카테고리) — Concept
User (유저)
- U_ID (Key) — PK — Primary key — NOT NULL
- Email (이메일(ID)) — Text
- PW (패스워드) — Text
- Name (이름) — Text
- Company (소속회사) — Text