ㄴㅁㅇ

Tables (19)

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 — NUMBER — Primary key — NOT NULL
  • member_id — VARCHAR2(30) — NOT NULL
  • reserve_date — TIMESTAMP — NOT NULL
  • price — NUMBER — NOT NULL
  • check_in — DATE — NOT NULL
  • check_out — DATE — NOT NULL
  • guest_num — NUMBER — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • mileage — NUMBER
  • room_id — NUMBER — NOT NULL

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

Travel_Type

  • CREATE — TABLE — Primary key — 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 — 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