tripnote_erd
Tables (19)
area
- id — NUMBER
- parent_id — NUMBER
- area_name — VARCHAR2(255)
attractions
- contentid — VARCHAR2(20)
- title — VARCHAR2(255)
- addr1 — VARCHAR2(255)
- firstimage — CLOB
- mapx — VARCHAR2(255)
- mapy — VARCHAR2(255)
- overview — CLOB
- locations — VARCHAR2(100)
board
- id — NUMBER
- title — VARCHAR2(100)
- board_content — CLOB
- created_at — TIMESTAMP
- modified_at — TIMESTAMP
- is_private — NUMBER(1)
- is_visible — NUMBER(1)
- is_draft — NUMBER(1)
- user_id — NUMBER — NOT NULL
- course_id — NUMBER — NOT NULL
- thumbnail — VARCHAR2(255)
course
- id — NUMBER
- title — VARCHAR2(100)
- created_at — TIMESTAMP
- start_date — DATE — NOT NULL
- end_date — DATE
- is_visible — NUMBER(1)
- user_id — NUMBER — NOT NULL
- area_id — NUMBER — NOT NULL
course_icon
- course_id — NUMBER
- icon_name — VARCHAR2(50)
follow
- id — NUMBER
- follow_id — NUMBER — NOT NULL
- user_id — NUMBER — NOT NULL
hotels
- contentid — VARCHAR2(20)
- title — VARCHAR2(255)
- addr1 — VARCHAR2(255)
- firstimage — CLOB
- mapx — VARCHAR2(255)
- mapy — VARCHAR2(255)
- overview — CLOB
- locations — VARCHAR2(100)
likes
- id — NUMBER
- board_id — NUMBER — NOT NULL
- user_id — NUMBER — NOT NULL
member
- id — NUMBER
- course_id — NUMBER — NOT NULL
- user_id — NUMBER — NOT NULL
members
- from_user_id — NUMBER
- to_user_id — NUMBER
- course_id — NUMBER
- invitation_url — VARCHAR2(1000)
note
- id — NUMBER
- note_content — CLOB
- note_day — DATE
- tour_loc_id — NUMBER — NOT NULL
recommend
- id — NUMBER
- code — VARCHAR2(255)
- user_id — NUMBER — NOT NULL
reply
- id — NUMBER
- reply_content — VARCHAR2(4000)
- created_at — TIMESTAMP
- modified_at — TIMESTAMP
- board_id — NUMBER — NOT NULL
- reply_id — NUMBER
- user_id — NUMBER — NOT NULL
restaurants
- contentid — VARCHAR2(20)
- title — VARCHAR2(255)
- addr1 — VARCHAR2(255)
- firstimage — CLOB
- mapx — VARCHAR2(255)
- mapy — VARCHAR2(255)
- overview — CLOB
- locations — VARCHAR2(100)
review_content
- id — NUMBER
- review_content — CLOB
- img — VARCHAR2(255)
- tour_loc_id — NUMBER — NOT NULL
- is_draft — NUMBER(1)
tour_loc
- id — NUMBER
- code — VARCHAR2(100)
- tour_loc_name — VARCHAR2(255)
- tour_order — NUMBER(20)
- start_time — VARCHAR2(50)
- end_time — VARCHAR2(50)
- tour_nth — NUMBER(10)
- time_taken — NUMBER(5)
- img_src — VARCHAR2(255)
- type_name — VARCHAR2(15)
- course_id — NUMBER — NOT NULL
- is_recommend — NUMBER(1)
tour_loc_xy
- tour_loc_id — NUMBER
- mapx — VARCHAR2(255)
- mapy — VARCHAR2(255)
tour_tag
- id — NUMBER
- tag_name — CLOB
- tour_loc_id — NUMBER — NOT NULL
users
- id — NUMBER
- username — VARCHAR2(50)
- password — VARCHAR2(255)
- email — VARCHAR2(255) — NOT NULL
- users_name — VARCHAR2(50)
- nickname — VARCHAR2(100)
- profile_image — VARCHAR2(500)