쇼핑몰_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)