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로