example

Tables (8)

Cart

  • cart_no — int(50) — Primary key — NOT NULL
  • cart_m_id — varchar(15) — Foreign key → Customer.m_id — NOT NULL
  • cart_p_no — varchar(30) — Foreign key → Product.p_no — NOT NULL
  • cart_amount — int(50)

Customer

  • m_id — varchar(15) — Primary key — NOT NULL
  • m_pw — varchar(20)
  • m_name — varchar(10)
  • m_phone — varchar(20)
  • m_address — varchar(40)
  • m_email — varchar(30)
  • m_regdate — date
  • m_savemoney — int(30)

Event_product

  • e_no — varchar(30) — Primary key — NOT NULL
  • e_sotck — int(20)
  • e_name — varchar(100)
  • e_cost — int(100)
  • e_description — varchar(150)
  • e_date — date
  • e_company — varchar(20)
  • e_image — mediumblob
  • e_color — varchar(30)
  • e_discount_rate — varchar(30)
  • e_buy_count — int(200)

Order

  • order_no — varchar(20) — Primary key — NOT NULL
  • order_m_id — varchar(15) — Foreign key → Customer.m_id — NOT NULL
  • order_recv_name — varchar(30)
  • order_recv_address — varchar(100)
  • order_recv_phone — vharchar(30)
  • order_date — date
  • order_requirement — varchar(100)
  • order_total_cost — int(30)

Order_detail

  • p_no — varchar(30) — NOT NULL
  • order_no — varchar(20) — NOT NULL
  • count — int(30)

Product

  • p_no — varchar(30) — Primary key — NOT NULL
  • p_sotck — int(20)
  • p_name — varchar(100)
  • p_cost — int(100)
  • p_description — varchar(150)
  • p_date — date
  • p_company — varchar(20)
  • p_category_code — varchar(50) — NOT NULL
  • p_image — mediumblob
  • p_color — varchar(30)
  • p_size — varchar(20)
  • p_star — varchar(20)
  • p_discount_rate — varchar(30)
  • p_buy_count — int(200)

Product_category

  • p_category_code — vharchar(50) — Primary key — NOT NULL
  • p_category_name — varchar(50)

Review

  • r_no — vharchar(30) — Primary key — NOT NULL
  • p_no — varchar(30) — NOT NULL
  • r_date — date
  • r_title — varchar(50)
  • r_content — varchar(50)
  • r_image — mediumblob