Travel
Tables (7)
Member
- member_id — varcahr(30) — Primary key — NOT NULL
- member_password — varchar(20) — NOT NULL
- member_name — varchar(15) — NOT NULL
- member_address — varchar(50)
- member_email — varcahr(30)
- member_tel — varchar(20)
- member_author — varchar(2) — 권한(관리자
- member_favorite — varchar(100)
Notice
- notice_no — varchar(10)
- notice_title — varchar(100)
- notice_date — date
- notice_content — varchar(1000) — 리뷰
- notice_type — varchar(20)
Product
- product_no — number(10) — Primary key — NOT NULL
- product_date — varchar(40) — NOT NULL
- product_name — varchar(100)
- product_price — int
- product_img — varchar(200)
- product_img_name — varchar(200)
QnA
- qna_no — varchar(10) — Primary key — NOT NULL
- qna_title — varchar(100)
- qna_date — date
- qna_content — varchar(1000) — 문의내용
- member_id — varchar(30) — NOT NULL
Reply
- reply_no — varchar(10) — Primary key — NOT NULL
- qna_no — varchar(10) — Foreign key → QnA.qna_no — NOT NULL
- reply_id — varchar(30)
- reply_date — date
- reply_content — varchar(1000) — 문의
- member_id — varchar(30) — NOT NULL
Reservation
- reservation_no — varchar(10) — Primary key — NOT NULL
- member_id (member_id2) — varcahr(30) — Foreign key → Member.member_id — NOT NULL
- product_name — varchar(100)
- reservation_person — int — 최소인원
- total_price — int — 자바에서
- card_name — varchar(20)
- card_pay — int
- cash_account — varcahr(15)
- cash_user_name — varchar(15)
- cash_price — int
- product_no — number(10) — NOT NULL
- member_id — varchar(30) — NOT NULL
- product_no (product_no2) — number(10) — Foreign key → Product.product_no — NOT NULL
Review
- member_id (member_id2) — varcahr(30) — Foreign key → Member.member_id — NOT NULL
- review_no — varchar(10)
- review_title — varchar(100)
- review_date — date
- review_content — varchar(1000) — 리뷰
- review_score — varchar(20)
- review_img — varchar(300) — 사진
- member_id — varchar(30) — NOT NULL
- review_img_dir — varchar
- review_local — varchar — 1~4로