shop
Tables (10)
cart
- customer_id — varchar(50) — Foreign key → customer.customer_id — NOT NULL
- goods_no — int(11) — Foreign key → goods.goods_no — NOT NULL
- cart_totalcount — int(11) — NOT NULL
- cart_totalprice — int(11) — NOT NULL
- update_date — datetime — NOT NULL
- create_date — datetime — NOT NULL
comment
- comment_no — int(11) — Primary key — NOT NULL
- notice_no — int(11) — Foreign key → notice.notice_no — NOT NULL
- id — varchar(50) — NOT NULL
- comment_content — text — NOT NULL
- comment_pw — varchar(50) — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
customer
- customer_id — varchar(50) — Primary key — NOT NULL
- customer_pass — varchar(50) — NOT NULL
- customer_name — varchar(50) — NOT NULL
- customer_address — varchar(150) — NOT NULL
- customer_telephone — varchar(50) — NOT NULL
- update_date — datetime — NOT NULL
- create_date — datetime — NOT NULL
employee
- employee_id — varchar(50) — Primary key — NOT NULL
- employee_pass — varchar(50) — NOT NULL
- employee_name — varchar(50) — NOT NULL
- update_date — datetime — NOT NULL
- create_date — datetime — NOT NULL
- active — enum('Y','N') — NOT NULL
goods
- goods_no — int(11) — Primary key — NOT NULL
- goods_menu — enum('캣타워','생활/리빙용품','목욕/미용용품','배변용품','건식사료','습식사료','고양이간식&영양제','장난감','스크레쳐') — NOT NULL
- goods_name — varchar(50) — NOT NULL
- goods_price — int(11) — NOT NULL
- update_date — datetime — NOT NULL
- create_date — datetime — NOT NULL
- sold_out — enum('Y','N') — NOT NULL
goods_img
- goods_no — int(11) — Foreign key → goods.goods_no — NOT NULL
- filename — varchar(50) — NOT NULL
- origin_filename — varchar(50) — NOT NULL
- content_type — varchar(50) — NOT NULL
- create_date — datetime — NOT NULL
notice
- notice_no — int(11) — Primary key — NOT NULL
- notice_title — varchar(50) — NOT NULL
- notice_content — text — NOT NULL
- notice_id — varchar(50) — Foreign key → employee.employee_id — NOT NULL
- update_date — datetime — NOT NULL
- create_date — datetime — NOT NULL
- notice_show — enum('Y','N') — NOT NULL
orders
- order_no — int(11) — Primary key — NOT NULL
- goods_no — int(11) — Foreign key → goods.goods_no — NOT NULL
- customer_id — varchar(50) — Foreign key → customer.customer_id — NOT NULL
- order_quantity — int(11) — NOT NULL
- order_price — int(11) — NOT NULL
- order_address — varchar(500) — NOT NULL
- order_state — enum('주문취소','배송전','배송중','배송완료') — NOT NULL
- update_date — datetime — NOT NULL
- create_date — datetime — NOT NULL
outid
- out_id — varchar(50) — Primary key — NOT NULL
- out_date — datetime — NOT NULL
review
- review_no — int(11) — Primary key — NOT NULL
- good_no — int(11) — Foreign key → goods.goods_no — NOT NULL
- id — varchar(50) — NOT NULL
- review_content — text — NOT NULL
- review_pw — varchar(50) — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL