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)