TTD_DB

Tables (15)

board

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • plan_id — BIGINT — Foreign key → plan.id
  • category_id — BIGINT — Foreign key → board_category.id
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • is_public — BOOLEAN — NOT NULL
  • like_count — INT — NOT NULL
  • comment_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME

board_category

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL

board_comment

  • id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → board.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME

board_image

  • id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → board.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • stored_filename — VARCHAR(255) — NOT NULL
  • sort_order — INT — NOT NULL

board_like

  • id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → board.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL

board_place

  • id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → board.id — NOT NULL
  • place_name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • category — VARCHAR(100)
  • phone — VARCHAR(50)
  • kakao_place_id — VARCHAR(100)
  • kakao_url — TEXT
  • longitude — DOUBLE — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • sort_order — INT — NOT NULL

board_view

  • id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → board.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • created_at — DATETIME — NOT NULL

culture_event

  • id — BIGINT — Primary key — NOT NULL
  • content_id — VARCHAR(100)
  • name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(20)
  • category_name — VARCHAR(20)
  • location — VARCHAR(255)
  • district — VARCHAR(50)
  • start_date — DATE
  • end_date — DATE
  • description — TEXT
  • image_url — TEXT
  • link_url — TEXT
  • latitude — DOUBLE
  • longitude — DOUBLE

member

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • profile_image — VARCHAR(255)
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • provider — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

place

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • address — TEXT
  • district — VARCHAR(20)
  • category_main — VARCHAR(50) — NOT NULL
  • category_sub — VARCHAR(100)
  • is_indoor — BOOLEAN — NOT NULL
  • mood — VARCHAR(20)
  • couple_friendly — BOOLEAN — NOT NULL
  • price_range — VARCHAR(20)
  • hashtags — VARCHAR(500)
  • description — TEXT
  • url — VARCHAR(300)
  • longitude — DOUBLE
  • latitude — DOUBLE
  • created_at — DATETIME

place_images

  • id — BIGINT — Primary key — NOT NULL
  • place_id — BIGINT — Foreign key → place.id — NOT NULL
  • image_url — TEXT — NOT NULL
  • sort_order — INT — NOT NULL

plan

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • plan_date — DATE
  • created_at — DATETIME — NOT NULL

plan_place

  • id — BIGINT — Primary key — NOT NULL
  • plan_id — BIGINT — Foreign key → plan.id — NOT NULL
  • place_type — VARCHAR(50) — NOT NULL
  • place_id — BIGINT
  • place_name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255)
  • category — VARCHAR(100)
  • phone — VARCHAR(50)
  • kakao_place_id — VARCHAR(100)
  • kakao_url — TEXT
  • longitude — DOUBLE
  • latitude — DOUBLE
  • sort_order — INT — NOT NULL
  • memo — TEXT

weather_cache

  • id — BIGINT — Primary key — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • weather_json — TEXT — NOT NULL

wish

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • place_type — VARCHAR(50) — NOT NULL
  • place_id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL