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