3팀 중고거래 프로젝트
테이블 (12)
admin
- admin_id — varchar(10)
- admin_passwd — varchar(45)
booking
- booking_idx — int — 기본 키 — NOT NULL
- booking_date — varchar(50)
- booking_time — varchar(45)
- booking_num — varchar(45)
- booking_seat — varchar(10)
- booking_content — varchar(200)
- store_idx — int
- member_id — varchar(45)
- merchant_uid — varchar(30)
member
- member_idx — int
- member_type — char(45)
- member_name — varchar(45)
- member_id — varchar(45)
- member_passwd — varchar(100)
- member_phone — varchar(45)
- member_email — varchar(45)
- member_birth — varchar(45)
- member_gender — varchar(45)
- member_join_date — date
- member_point — int
menu
- menu_idx — int
- menu_name — varchar(45)
- menu_type — varchar(45)
- menu_price — varchar(45)
- menu_image — varchar(45)
- menu_content — varchar(1000)
- store_idx — varchar(45)
- menu_image_path — varchar(200)
notice
- notice_idx — int
- notice_title — varchar(100)
- notice_content — varchar(5000)
- notice_date — date
- notice_file — varchar(200)
- notice_file_path — varchar(50)
pay
- merchant_uid — varchar(30)
- pay_price — varchar(45)
- pay_date — varchar(45)
- member_id — varchar(45)
report
- report_idx — int
- report_content — varchar(45)
- report_count — int
- store_idx — int
review
- review_idx — int
- review_content — varchar(1000)
- review_star — int
- review_date — date
- review_re_ref — int
- review_re_lev — int
- review_re_seq — int
- store_idx — int
- member_id — varchar(45)
- review_file — varchar(100)
- review_file_path — varchar(50)
- merchant_uid — varchar(30)
- delete_auth_status — char(1)
- review_report — varchar(1000)
- booking_idx — int
review_image
- review_image_idx — int
- review_image_file — varchar(45)
- review_idx — int
review_reply
- reply_idx — int
- review_idx — int
- reply_content — varchar(500)
- reply_date — timestamp
store
- store_idx — int
- store_name — varchar(45)
- store_phone — varchar(45)
- store_address — varchar(45)
- store_type — varchar(45)
- store_content — varchar(1000)
- store_time — varchar(45)
- store_license — varchar(45)
- store_date — varchar(45)
- store_etc — varchar(45)
- store_file — varchar(200)
- store_file_path — varchar(50)
- member_id — varchar(45)
- auth_status — char(1)
- store_open — varchar(30)
- store_close — varchar(30)
- store_maxps — varchar(30)
- report_mail_count — int
store_image
- store_image_idx — int
- store_image_file — varchar(45)
- store_idx — varchar(45)