shoperd

Tables (9)

board (Untitled)

  • board_no — int — Primary key — NOT NULL
  • board_title — varchar
  • board_writer — varchar
  • board_content — text
  • create_date — date

customer (Untitled2)

  • customer_id (cusotmer_id) — varchar — Primary key — NOT NULL
  • customer_pass — varchar
  • customer_name (cusotmer_name) — varchar
  • customer_address — varchar
  • customer_detail — varchar
  • customer_telephone — varchar
  • update_date — date
  • create_date — date

employee (Untitled3)

  • employe_id (employee_id) — varchar — Primary key — NOT NULL
  • employee_pass — varchar
  • employee_name — varchar
  • employee_address — varchar
  • employee_detail — varchar
  • update_date — date
  • create_date — date
  • active — 'Y' , 'N'

goods (Untitled4)

  • goods_no — int — Primary key — NOT NULL
  • goods_name — varchar
  • goods_price — int
  • update_date — date
  • create_date — date
  • sold_out — 'Y' , 'N'

goods_img (Untitled5)

  • goods_no — int — Primary key — NOT NULL
  • filename — varchar
  • origin_filename — varchar
  • content_type — varchar
  • create_date — date

notice (Untitled6)

  • notice_no — int — Primary key — NOT NULL
  • noticec_title (notice_title) — varchar
  • notice_content — text
  • update_date — date
  • create_date — date

orders (Untitled7)

  • order_no — int — Primary key — NOT NULL
  • customer_id (cusotmer_id) — varchar — Foreign key → customer.customer_id — NOT NULL
  • goods_no — int — Foreign key → goods.goods_no — NOT NULL
  • order_quantity — int
  • order_price — int
  • order_address — varchar
  • order_state — varchar
  • update_date — date
  • create_date — date

outid (Untitled8)

  • out_id — varchar — Primary key — NOT NULL
  • out_date — date

review (Untitled9)

  • order_no — int — Primary key — NOT NULL
  • review_content — text
  • update_date — date
  • create_date — date