E-ShoppingMall1
테이블 (7)
1:1 게시판 (1:1 Board)
- Id (cust_id) — VARCHAR(30) — 외래 키 → 회원.Id — NOT NULL
- #Inquiry (inq_cnt) — INT
- #Unchecked (unans_cnt) — INT
문의글 (Inquiry)
- Inquiry Number (inq_num) — VARCHAR(30) — 기본 키 — NOT NULL
- Id (cust_id) — VARCHAR(30) — 외래 키 → 1:1 게시판.Id — NOT NULL
- Content (content) — VARCHAR(225)
- Checked (is_checked) — BOOLEAN
- Date of inquiry (inq_date) — DATE
상품 (Product)
- Product Number (prod_num) — VARCHAR(30) — 기본 키 — NOT NULL
- Product Type (prod_type) — VARCHAR(30)
- Product Name (prod_name) — VARCHAR(225)
- Stock (stock) — INT
- Price (price) — INT
장바구니 (Cart)
- Id (cust_id) — VARCHAR(30) — 외래 키 → 회원.Id — NOT NULL
- #product (prod_cnt) — INT
- Total amount (cart_amt) — INT
- Product Number (prod_num) — VARCHAR(30) — 외래 키 → 상품.Product Number — NOT NULL
주문 (Order)
- Order number (ord_num) — VARCHAR(30) — 기본 키 — NOT NULL
- Id (cust_id) — VARCHAR(30) — 외래 키 → 회원.Id — NOT NULL
- Name (ord_cust_name) — VARCHAR(225)
- Phone (ord_cust_phone) — VARCAHR(13)
- Zip Code (ord_zip_code) — INT
- Address1 (ord_address1) — VARCHAR(225)
- Address2 (ord_address2) — VARCHAR(225)
- Payment Type (pay_type) — VARCHAR(10)
- Total amount (ord_amt) — INT
- Order Status (ord_status) — VARCHAR(10)
- Date of Order (ord_date) — DATE
회원 (Customer)
- Id (cust_id) — VARCHAR(30) — 기본 키 — NOT NULL
- Password (cust_pass) — VARCHAR(225)
- Name (cust_name) — VARCHAR(225)
- Phone (cust_phone) — VARCAHR(13)
- Zip Code (zip_code) — INT
- Address1 (address1) — VARCHAR(225)
- Address2 (address2) — VARCHAR(225)