Travel_TeamProject

Tables (4)

BOOKING (상품예약)

  • booking_num (예약번호) — NUMBER — Primary key — NOT NULL
  • product_num (상품번호2) — NUMBER — Foreign key → PRODUCTS.product_num — NOT NULL
  • customer_id (회원아이디2) — VARCHAR2(30) — Foreign key → TRAVEL_CUSTOMERS.customer_id — NOT NULL
  • member_num (인원수) — NUMBER
  • travel_period (기간) — NUMBER
  • wholeperiod_price (전체가격) — NUMBER

PRODUCTS (상품목록)

  • product_num (상품번호) — NUMBER — Primary key — NOT NULL
  • product_title (상품명) — VARCHAR2(500)
  • product_text (상품설명) — VARCHAR2(2000)
  • product_price (가격) — NUMBER
  • product_clickcount (조회수) — NUMBER

REVIEWS (상품후기)

  • review_num (후기번호) — NUMBER — Primary key — NOT NULL
  • product_num (상품번호2) — NUMBER — Foreign key → PRODUCTS.product_num — NOT NULL
  • customer_id (회원아이디2) — VARCHAR2(30) — Foreign key → TRAVEL_CUSTOMERS.customer_id — NOT NULL
  • review_score (평점) — NUMBER
  • review_text (후기글내용) — VARCHAR2(2000)
  • regdate (후기작성일) — DATE

TRAVEL_CUSTOMERS (회원가입)

  • customer_id (회원아이디) — VARCHAR2(30) — Primary key — NOT NULL
  • customer_pw (회원비밀번호) — VARCHAR2(30)
  • customer_name (이름) — VARCHAR2(30)
  • customer_email (이메일) — VARCHAR2(50)