GAJE-ERD
Tables (21)
BOOKMARK
- bookmark_id — INT
- user_id — INTEGER — NOT NULL
- post_id — INTEGER — NOT NULL
- created_at — DATETIME
COMMENT
- comment_id — INTEGER
- post_id — INTEGER — NOT NULL
- user_id — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- mentioned_user_id — INTEGER
- like_count — INT
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
COMMENT_LIKE
- user_id — INTEGER — Primary key — NOT NULL
- comment_id — INTEGER — Primary key — NOT NULL
- created_at — DATETIME
COURSE
- course_id — INTEGER
- user_id — INTEGER — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
COURSE_PLACE
- course_place_id — INTEGER
- course_id — INTEGER — NOT NULL
- place_id — INTEGER — NOT NULL
- sequence — INT — NOT NULL
- estimated_stay_minutes — INT
- expected_cost — INT
- note — TEXT
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
INQUIRY
- inquiry_id — INTEGER
- user_id — INTEGER — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- file_url — VARCHAR(1000)
- answer — TEXT
- is_answered — BOOLEAN
- created_at — DATETIME
- answered_at — DATETIME
NOTICE
- notice_id — INTEGER
- admin_id — INTEGER — NOT NULL
- title — VARCHAR(150) — NOT NULL
- content — TEXT — NOT NULL
- is_pinned — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
PLACE
- place_id — INTEGER
- name — VARCHAR(200) — NOT NULL
- address — VARCHAR(300)
- address_detail — VARCHAR(300)
- phone — VARCHAR(30)
- homepage — VARCHAR(1000)
- description — TEXT
- content_id — INTEGER
- content_type_id — INTEGER
- area_code — INT
- first_image1 — VARCHAR(1000)
- first_image2 — VARCHAR(1000)
- map_level — INT
- latitude — DECIMAL(20,17)
- longitude — DECIMAL(20,17)
- view_count — INT
- is_deleted — BOOLEAN
- created_at — DATETIME
PLACE_REVIEW
- review_id — INTEGER
- post_id — INTEGER — NOT NULL
- place_id — INTEGER — NOT NULL
- stay_duration_minutes — INT
- short_review — TEXT
- image_url — VARCHAR(1000)
- is_deleted — BOOLEAN
- created_at — DATETIME
PLACE_TAG
- place_id — INTEGER — Primary key — NOT NULL
- tag_id — INTEGER — Primary key — NOT NULL
POST
- post_id — INTEGER
- user_id — INTEGER — NOT NULL
- course_id — INTEGER — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- view_count — INTEGER
- is_deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
POST_HISTORY
- user_id — INTEGER — Primary key — NOT NULL
- post_id — INTEGER — Primary key — NOT NULL
- viewed_at — DATETIME
POST_LIKE
- user_id — INTEGER — Primary key — NOT NULL
- post_id — INTEGER — Primary key — NOT NULL
- created_at — DATETIME
POST_TAG
- post_id — INTEGER — Primary key — NOT NULL
- tag_id — INTEGER — Primary key — NOT NULL
TAG
- tag_id — INTEGER
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME
USER
- user_id — INTEGER
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — vARCHAR(10)
- age — INTEGER
- phone — VARCHAR(20)
- is_deleted — BOOLEAN
- regist_at — DATETIME
- last_login_at — DATETIME
favorite
- member_id — BIGINT
- post_id — BIGINT
- created_at — DATETIME
member
- id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50)
- age — INT
- profile_image_url — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
post
- id — BIGINT
- title — VARCHAR(200) — NOT NULL
- content — TEXT
- thumbnail — VARCHAR(255)
- region — VARCHAR(50)
- theme — VARCHAR(50)
- author_id — BIGINT — NOT NULL
- view_count — INT
- like_count — INT
- created_at — DATETIME
- updated_at — DATETIME
post_plan
- id — BIGINT
- post_id — BIGINT — NOT NULL
- seq — INT — NOT NULL
- place_id — VARCHAR(100)
- lat — DECIMAL(9,6)
- lng — DECIMAL(9,6)
- est_time — DATETIME
- cost — INT
post_record
- id — BIGINT
- post_id — BIGINT — NOT NULL
- plan_id — BIGINT
- image_url — VARCHAR(255)
- review — TEXT
- created_at — DATETIME