Trablock

Tables (16)

article

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255)
  • expense — VARCHAR(255)
  • cover_img_url — VARCHAR(255)
  • travel_companion — VARCHAR(255)
  • status — ENUM('ACTIVE', 'INACTIVE')
  • start_at — DATE
  • end_at — DATE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

article_location

  • id (article_id) — BIGINT — Foreign key → article.id — NOT NULL
  • address — VARCHAR(255)
  • city — VARCHAR(255)
  • place_id — VARCHAR(255)

article_schedule

  • id — BIGINT — Primary key — NOT NULL
  • id (article_id) — BIGINT — Foreign key → article.id — NOT NULL
  • duration_time — TIME(4) — NOT NULL
  • sort_order — TINYINT — NOT NULL
  • visited_date — DATE — NOT NULL
  • visited_time — TIME(4) — NOT NULL
  • category — VARCHAR(15) — NOT NULL
  • expense — VARCHAR(15) — NOT NULL
  • dtype — VARCHAR(31) — NOT NULL
  • memo — VARCHAR(500)
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

article_travel_styles

  • id (article_id) — BIGINT — Foreign key → article.id — NOT NULL
  • travel_styles — VARCHAR(255)

article_views

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
  • id (article_id) — BIGINT — Foreign key → article.id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

bookmark

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
  • id (article_id) — BIGINT — Foreign key → article.id — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

comment

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
  • id (review_id) — BIGINT — Foreign key → review.id — NOT NULL
  • reply_comment — TEXT — NOT NULL — EXT NOT NUL
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

comment_like

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
  • id (comment_id) — BIGINT — Foreign key → comment.id — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

pw_answer

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
  • id (pw_question_id) — BIGINT — Foreign key → pw_question.id — NOT NULL
  • answer — VARCHAR(255) — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE')
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

pw_question

  • id — BIGINT — Primary key — NOT NULL
  • question — VARCHAR(255) — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

review

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
  • id (article_id) — BIGINT — Foreign key → article.id — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • description — TEXT — NOT NULL
  • representative_img_url — VARCHAR(255)
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

review_like

  • id — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
  • id (review_id) — BIGINT — Foreign key → review.id — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

schedule_etc

  • id (schedule_id) — BIGINT — Foreign key → article_schedule.id — NOT NULL
  • place_name — VARCHAR(255) — NOT NULL

schedule_general

  • id (schedule_id) — BIGINT — Foreign key → article_schedule.id — NOT NULL
  • google_map_latitude — DECIMAL(10,8) — NOT NULL
  • google_map_longitude — DECIMAL(11,8) — NOT NULL
  • google_map_phone_number — VARCHAR(20)
  • google_map_address — VARCHAR(500)
  • google_map_home_page_url — VARCHAR(1000)
  • google_map_place_id — VARCHAR(255) — NOT NULL
  • place_name — VARCHAR(255) — NOT NULL

schedule_transport

  • id (schedule_id) — BIGINT — Foreign key → article_schedule.id — NOT NULL
  • google_map_start_latitude — DECIMAL(10,8) — NOT NULL
  • google_map_start_longitude — DECIMAL(11,8) — NOT NULL
  • google_map_end_latitude — DECIMAL(10,8) — NOT NULL
  • google_map_end_longitude — DECIMAL(11,8) — NOT NULL
  • transportation — VARCHAR(20) — NOT NULL
  • google_map_start_place_address — VARCHAR(500) — NOT NULL
  • google_map_end_place_address — VARCHAR(500) — NOT NULL
  • start_place_name — VARCHAR(255) — NOT NULL
  • end_place_name — VARCHAR(255) — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • is_agreement — BIT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • introduce — VARCHAR(255)
  • nickname — VARCHAR(255)
  • password — VARCHAR(255)
  • profile_img_url — VARCHAR(255)
  • username — VARCHAR(255)
  • role — ENUM('ADMIN', 'USER')
  • status — ENUM('ACTIVE', 'INACTIVE')