travle_team

Tables (16)

ADMINS

  • admin_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP

AI_LOG

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • request_type — VARCHAR(50)
  • input_text — TEXT
  • output_text — TEXT
  • recommended_place — BIGINT
  • reason — TEXT
  • created_at — TIMESTAMP

CHATBOT

  • id — BIGINT
  • user_id — BIGINT
  • session_id — VARCHAR(100)
  • sender — VARCHAR(10)
  • message — TEXT
  • bot_persona — VARCHAR(50)
  • nickname — VARCHAR(100)
  • created_at — TIMESTAMP

COMMENTS

  • comment_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • parent_comment_id — BIGINT
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • image_url — VARCHAR(500)

FAVORITES

  • favorite_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • post_id — BIGINT
  • comment_id — BIGINT
  • map_location — VARCHAR(255)
  • created_at — TIMESTAMP

FRIENDS

  • friend_id — BIGINT
  • requester_id — BIGINT — NOT NULL
  • receiver_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

LIKES

  • like_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • post_id — BIGINT
  • comment_id — BIGINT
  • review_id — BIGINT
  • created_at — TIMESTAMP

LOGIN_LOG

  • log_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • login_time — TIMESTAMP
  • ip_address — VARCHAR(100)
  • device_info — VARCHAR(255)
  • login_success — BOOLEAN

NOTICE

  • notice_id — BIGINT
  • admin_id — BIGINT — NOT NULL
  • is_fixed — BOOLEAN
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • view_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • file_url — VARCHAR(500)
  • category — VARCHAR(50)

PLACES

  • id — BIGINT
  • region — VARCHAR(100)
  • name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(50)
  • address — VARCHAR(255)
  • lat — DOUBLE
  • lng — DOUBLE
  • description — TEXT
  • image_url — VARCHAR(500)
  • rating — DECIMAL(2,1)
  • created_at — TIMESTAMP

POSTS

  • post_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • category — VARCHAR(50)
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • views — INT
  • image_url — VARCHAR(1000)
  • video_url — VARCHAR(500)
  • youtube_url — VARCHAR(500)
  • map_location — VARCHAR(255)
  • tags — VARCHAR(255)

REPORT_COMMENT

  • report_id — BIGINT
  • comment_id — BIGINT — NOT NULL
  • reporter_id — BIGINT — NOT NULL
  • target_user_id — BIGINT — NOT NULL
  • reason — VARCHAR(255)
  • created_at — TIMESTAMP
  • status — VARCHAR(20)
  • admin_id — BIGINT
  • processed_at — TIMESTAMP

REPORT_POST

  • report_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • reporter_id — BIGINT — NOT NULL
  • target_user_id — BIGINT — NOT NULL
  • reason — VARCHAR(255)
  • created_at — TIMESTAMP
  • status — VARCHAR(20)
  • admin_id — BIGINT
  • processed_at — TIMESTAMP

SCHEDULE

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • schedule_title — VARCHAR(255) — NOT NULL
  • region — VARCHAR(100)
  • date — DATE
  • time — VARCHAR(50)
  • place_name — VARCHAR(255)
  • address — VARCHAR(255)
  • transportation — VARCHAR(50)
  • cost — DECIMAL(10,2)
  • memo — TEXT
  • lodging_name — VARCHAR(255)
  • lodging_checkin — TIMESTAMP
  • lodging_checkout — TIMESTAMP
  • created_at — TIMESTAMP

USERS

  • user_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image — VARCHAR(500)
  • phone — VARCHAR(50)
  • birth_year — INT
  • gender — VARCHAR(10)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — VARCHAR(20)

USER_DATA

  • id — BIGINT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(100)
  • nickname — VARCHAR(100)
  • phone — VARCHAR(50)
  • profile_image — VARCHAR(500)
  • notification — VARCHAR(20)
  • theme — VARCHAR(20)
  • language — VARCHAR(20)
  • total_trips — INT
  • visited_regions — TEXT
  • created_at — TIMESTAMP
  • schedule_list — TEXT