asd
Tables (18)
Banner
- banner_id — NUMBER — Primary key — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- image_name — VARCHAR2(300) — NOT NULL
- link_url — VARCHAR2(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 — VARCHAR2(300) — NOT NULL
- contents — VARCHAR2(4000) — NOT NULL
- writer — VARCHAR2(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 — VARCHAR2(200) — NOT NULL
- sysname — VARCHAR2(200) — NOT NULL
- regdate — TIMESTAMP — NOT NULL
- parent_seq — NUMBER — NOT NULL
Members
- id — VARCHAR2(30) — Primary key — NOT NULL
- pw — VARCHAR2(128) — NOT NULL
- name — VARCHAR2(30) — NOT NULL
- nickname — VARCHAR2(50) — NOT NULL
- phone — VARCHAR2(30) — NOT NULL
- email — VARCHAR2(100) — NOT NULL
- gender — VARCHAR2(10) — NOT NULL
- dob — VARCHAR2(10) — NOT NULL
- zipcode — VARCHAR2(10)
- address1 — VARCHAR2(200)
- address2 — VARCHAR2(100)
- regdate — TIMESTAMP — NOT NULL
- mileage — NUMBER
Notice
- notice_id — NUMBER — Primary key — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- contents — VARCHAR2(2000) — NOT NULL
- writer — VARCHAR2(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 — VARCHAR2(30) — NOT NULL
- pw — VARCHAR2(30) — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- contents — VARCHAR2(2000) — NOT NULL
- write_date — TIMESTAMP — NOT NULL
- status — VARCHAR2(20) — NOT NULL
Reply
- seq — NUMBER — Primary key — NOT NULL
- board_seq — NUMBER
- parent_seq — NUMBER — NOT NULL
- writer — VARCHAR2(30) — NOT NULL
- contents — VARCHAR2(900) — NOT NULL
- write_date — TIMESTAMP — NOT NULL
Reservation
- seq — VARCHAR2(255) — Primary key — NOT NULL
- reserevid — VARCHAR2(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 — VARCHAR2(20) — NOT NULL
- mileage — NUMBER
Review
- seq — NUMBER — Primary key — NOT NULL
- member_id — VARCHAR2(30) — NOT NULL
- target_type — VARCHAR2(20) — NOT NULL
- target_id — NUMBER — NOT NULL
- contents — VARCHAR2(1000) — NOT NULL
- rating — NUMBER(2,1) — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
Room
- room_id — NUMBER — Primary key — NOT NULL
- place_id — NUMBER — NOT NULL
- room_name — VARCHAR2(200) — NOT NULL
- room_count — NUMBER
- base_count — NUMBER
- max_count — NUMBER
- price_weekday — NUMBER
- price_weekend — NUMBER
- image1 — VARCHAR2(300)
- amenities — VARCHAR2(300)
- intro — VARCHAR2(2000)
- reg_date — TIMESTAMP
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 — VARCHAR2(30) — NOT NULL
- target_type — VARCHAR2(20) — NOT NULL
- target_id — NUMBER — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
attendance
- attendance_id — NUMBER — Primary key — NOT NULL
- member_id — VARCHAR2(30) — NOT NULL
- attendance_date — DATE
- stampdays — NUMBER