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')