쇼핑몰_DB설계
테이블 (9)
Administrator (administrator)
- ASsn (assn) — INT(11) — 기본 키 — NOT NULL
- Access Level (access_level) — INT(1)
- ID (id) — VARCHAR(255)
- Password (password) — VARCHAR(255)
- First Name (fist_name) — VARCHAR(11)
- Last Name (last_name) — VARCHAR(11)
- Email (email) — VARCHAR(255)
- Brithday (brithday) — DATE
- Phone (phone) — VARCHAR(255)
Brand (brand)
- Brand ID (brand_id) — INT(11) — 기본 키 — NOT NULL
- Brand Name (brand name) — VARCHAR(255)
- Brand accumulative Sales (brand accumulative Sales) — INT(11)
Coupon (coupon)
- Coupon_SSN (couple_ssn) — INT(11) — 기본 키 — NOT NULL
- Discount_rate (discount_rate) — INT(11)
- Verification Code (verification_code) — INT(11)
- Create Date (create_date) — DATE
- Verification Start Date (start_date) — DATE
- Verification End Date (end_date) — DATE
Customer (customer)
- Ssn (ssn) — INT(11) — 기본 키 — NOT NULL
- Access Level (access_level) — INT(1)
- ID (id) — VARCHAR(255)
- Password (password) — VARCHAR(255)
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(255)
- Email (email) — VARCHAR(255)
- Address (address) — VARCHAR(255)
- Post Address Number (post_address_number) — NUMBER(5)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — DATE
- Social Secret Number (social_secret_number) — VARCHAR(255)
- Term of Service (term_of_service) — NUMBER(1)
- Order_ssn (order_ssn) — INT(11) — 외래 키 → Order_product.Order_ssn — NOT NULL
- Order Date (order_date) — DATE
- Arrival Date (arrival_date) — DATE
- Arrival Check (arrival_check) — INT(1)
- Refund_ssn (refund_ssn) — INT(11) — 외래 키 → Refund_Product.Refund_ssn — NOT NULL
- Customer Level (customer_level) — INT(1)
- Accumulative_Purchase (accumulative_purchase) — NUMBER(8)
- Drop (drop) — CHAR(1)
- Review (review) — VARCHAR(255)
- Coupon_SSN (couple_ssn) — INT(11) — 외래 키 → Coupon.Coupon_SSN — NOT NULL
- Discount_Point (discount_point) — INT(11)
- Purchase ID (purchase_id) — INT(11) — 외래 키 → Purchase System.Purchase ID — NOT NULL
FAQ (faQ)
- Content ID (content ID) — INT(11) — 기본 키 — NOT NULL
- Ssn (ssn) — INT(11) — 외래 키 → Customer.Ssn — NOT NULL
- Complain Category (complain_category) — VARCHAR(11)
- Title (title) — VARCHAR(255)
- Content (content) — VARCHAR(255)
- Content File (content_file) — VARCHAR(255)
- Content Password (content_password) — VARCHAR(255)
- Security Check (security_check) — INT(1)
- Create Date (create_date) — DATE
- Visit Number (visit_number) — INT(11)
Order_product (order_product)
- Order_ssn (order_ssn) — INT(11) — 기본 키 — NOT NULL
- Product_ssn (product_ssn) — INT(11) — 외래 키 → Product.Product_ssn — NOT NULL
- Number (number) — NUMBER(11)
- Post Address (post_address) — VARCHAR(8)
- Post Address Number (post_address_number) — INT(5)
- Order_Date (order_date) — DATE
- Arrival_Date (arrival_date) — DATE
- Arrival Check (arrival_check) — INT(1)
Product (product)
- Product_ssn (product_ssn) — INT(11) — 기본 키 — NOT NULL
- Product Name (prodcut_name) — VARCHAR(50)
- Price (price) — NUMBER(10)
- Category (category) — VARCHAR(11)
- Option1 (option1) — VARCHAR(50)
- Option2 (option2) — VARCHAR(50)
- Option3 (option3) — VARCHAR(50)
- IsPromtion (is_promtion) — VARCHAR(50)
- Discount (discount) — INT(11)
- Discount Point (discount_point) — INT(11)
- Review (review) — VARCHAR(255)
- Image1 (image) — VARCHAR2(4000)
- Image2 (image2) — VARCHAR2(4000)
- Image3 (image3) — VARCHAR2(4000)
- Accumulative Sales (accumulative_sales) — INT(11)
- Stock (stock) — INT(11)
- Delivery Prediction (delivery_prediction) — DATE
- Key — 외래 키 → Brand.Brand ID — NOT NULL
Purchase System (purchase system)
- Purchase ID (purchase_id) — INT(11) — 기본 키 — NOT NULL
- Card Brand (card_brand) — VARCHAR(11)
- Purchase_method — VARCHAR(11)
- Success (success) — INT(1)
- Order_ssn (order_ssn) — INT(11) — 외래 키 → Order_product.Order_ssn — NOT NULL
- Product_ssn (product_ssn) — INT(11) — 외래 키 → Product.Product_ssn — NOT NULL
Refund_Product (refund_product)
- Refund_ssn (refund_ssn) — INT(11) — 기본 키 — NOT NULL
- Product_ssn (product_ssn) — INT(11) — 외래 키 → Product.Product_ssn — NOT NULL
- Number (number) — NUMBER(11)
- Post Address (post_address) — VARCHAR(255)
- Post Address Number (post_address_number) — INT(5)
- Apply Date (apply_date) — DATE
- CheckRefund (check_refund_avilable) — INT(1)