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