KoreaTrip
Tables (17)
Banner
- banner_id — number — Primary key — NOT NULL
- title — varchar(200) — NOT NULL
- image_name — varchar(300) — NOT NULL
- link_url — varchar(500) — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- sort_order — number — NOT NULL
Board
- seq — number — Primary key — NOT NULL
- title — varchar(300) — NOT NULL
- contents — varchar(4000) — NOT NULL
- writer — varchar(30) — NOT NULL
- view_count — number — NOT NULL
- write_date — timestamp — NOT NULL
Bookmark
- bookmark_id — number — Primary key — NOT NULL
- board_seq — number — NOT NULL
- bookmark_date — timestamp — NOT NULL
Files
- seq — number — Primary key — NOT NULL
- oriname — varchar(200) — NOT NULL
- sysname — varchar(200) — NOT NULL
- regdate — timestamp — NOT NULL
- parent_seq — number — NOT NULL
Members
- id — varchar(30) — Primary key — NOT NULL
- pw — varchar(128) — NOT NULL
- name — varchar(30) — NOT NULL
- nickname — varchar(50) — NOT NULL
- phone — varchar(30) — NOT NULL
- email — varchar(100) — NOT NULL
- gender — varchar(10) — NOT NULL
- dob — varchar(10) — NOT NULL
- zipcode — varchar(10)
- address1 — varchar(200)
- address2 — varchar(100)
- regdate — timestamp — NOT NULL
- mileage — number
Notice
- notice_id — number — Primary key — NOT NULL
- title — varchar(200) — NOT NULL
- contents — varchar(2000) — NOT NULL
- writer — varchar(30) — NOT NULL
- view_count — number — NOT NULL
- write_date — timestamp — NOT NULL
- important — char(1) — NOT NULL
Place
- place_id — NUMBER — Primary key — NOT NULL
- place_type — VARCHAR2(20) — NOT NULL
- name — VARCHAR2(200) — NOT NULL
- region — VARCHAR2(100) — NOT NULL
- sigungu — VARCHAR2(100)
- address — VARCHAR2(300) — NOT NULL
- latitude — NUMBER(10,7)
- longitude — NUMBER(10,7)
- tel — VARCHAR2(30)
- intro — VARCHAR2(2000)
- image_name — VARCHAR2(300)
- price — NUMBER
- avg_rating — NUMBER(2,1) — NOT NULL
- review_count — NUMBER — NOT NULL
- api_content_id — VARCHAR2(50)
- reg_date — TIMESTAMP — NOT NULL
Qna
- qid — number — Primary key — NOT NULL
- member_id — varchar(30) — NOT NULL
- pw — varchar(30) — NOT NULL
- title — varchar(200) — NOT NULL
- contents — varchar(2000) — NOT NULL
- write_date — timestamp — NOT NULL
- status — varchar(20) — NOT NULL
Reply
- seq — number — Primary key — NOT NULL
- board_seq — number
- parent_seq — number — NOT NULL
- writer — varchar(30) — NOT NULL
- contents — varchar(900) — NOT NULL
- write_date — timestamp — NOT NULL
Reservation
- seq — VARCHAR(255) — Primary key — NOT NULL
- reserevid — varchar(30) — NOT NULL
- reservedate — timestamp — NOT NULL
- price — number — NOT NULL
- check_in — date — NOT NULL
- check_out — date — NOT NULL
- guestnum — number — NOT NULL
- status — varchar(20) — NOT NULL
- mileage — number
Review
- seq — number — Primary key — NOT NULL
- member_id — varchar(30) — NOT NULL
- target_type — varchar(20) — NOT NULL
- target_id — number — NOT NULL
- contents — varchar(1000) — NOT NULL
- rating — number(2,1) — NOT NULL
- reg_date — timestamp — NOT NULL
Trip
- trip_id — NUMBER — Primary key — NOT NULL
- member_id — VARCHAR2(30) — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- region — VARCHAR2(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- headcount — NUMBER — NOT NULL
- theme — VARCHAR2(30)
- is_public — CHAR(1) — NOT NULL
- summary — VARCHAR2(1000)
- thumbnail — VARCHAR2(300)
- view_count — NUMBER — NOT NULL
- like_count — NUMBER — NOT NULL
- scrap_count — NUMBER — NOT NULL
- origin_trip_id — NUMBER
- reg_date — TIMESTAMP — NOT NULL
Trip_Like
- like_id — NUMBER — Primary key — NOT NULL
- trip_id — NUMBER — NOT NULL
- member_id — VARCHAR2(30) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
Trip_Place
- trip_place_id — NUMBER — Primary key — NOT NULL
- trip_id — NUMBER — NOT NULL
- day_no — NUMBER — NOT NULL
- sort_order — NUMBER — NOT NULL
- place_id — NUMBER — NOT NULL
- visit_time — VARCHAR2(10)
- memo — VARCHAR2(500)
Trip_Scrap
- scrap_id — NUMBER — Primary key — NOT NULL
- trip_id — NUMBER — NOT NULL
- member_id — VARCHAR2(30) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
Wishlist
- wishlist_id — number — Primary key — NOT NULL
- member_id — varchar(30) — NOT NULL
- target_type — varchar(20) — NOT NULL
- target_id — number — NOT NULL
- reg_date — timestamp — NOT NULL
attendance
- attendance_id — number — Primary key — NOT NULL
- member_id — varchar(30) — NOT NULL
- attendance_date — date
- stampdays — number