모먹?
테이블 (19)
TB_BOARD_COMMENT
- id — BIGINT
- post_id — BIGINT — 외래 키 → TB_BOARD_POST.id — NOT NULL
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- content — TEXT
- created_at — DATETIME — NOT NULL
- INDEX — idx_post_id
- INDEX — idx_user_id
TB_BOARD_POST
- id — BIGINT
- company_id — BIGINT — 외래 키 → TB_COMPANY.id — NOT NULL
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- like_count — INT
- comment_count — INT
- created_at — DATETIME — NOT NULL
- INDEX — idx_company_id
- INDEX — idx_user_id
TB_BOARD_POST_LIKE
- id — BIGINT
- post_id — BIGINT — 외래 키 → TB_BOARD_POST.id — NOT NULL
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_post_id
- INDEX — idx_user_id
TB_COMPANY
- id — BIGINT
- company_group_id — BIGINT — 외래 키 → TB_COMPANY_GROUP.id
- name — VARCHAR(255) — NOT NULL
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- created_at — DATETIME — NOT NULL
- INDEX — idx_company_group_id
TB_COMPANY_DOMAIN
- id — BIGINT
- company_id — BIGINT — 외래 키 → TB_COMPANY.id — NOT NULL
- domain — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_company_id
TB_COMPANY_GROUP
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
TB_EMAIL_VERIFICATION
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- verification_code — VARCHAR(20) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- expired_at — DATETIME
- verified_at — DATETIME
- created_at — DATETIME — NOT NULL
- INDEX — idx_email
TB_LOCATION_VERIFICATION
- id — BIGINT
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- verified_at — DATETIME
- expired_at — DATETIME
- created_at — DATETIME — NOT NULL
- INDEX — idx_user_id
TB_PUSH_NOTIFICATION
- id — BIGINT
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- type — VARCHAR(50)
- title — VARCHAR(255)
- body — TEXT
- target_type — VARCHAR(50)
- target_id — BIGINT
- is_read — BOOLEAN
- sent_at — DATETIME
- created_at — DATETIME — NOT NULL
- INDEX — idx_user_id
TB_PUSH_TOKEN
- id — BIGINT
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- device_type — VARCHAR(50)
- token — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- INDEX — idx_user_id
TB_RESTAURANT
- id — BIGINT
- external_id — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- category — VARCHAR(255)
- address — VARCHAR(500)
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- phone — VARCHAR(50)
- created_at — DATETIME — NOT NULL
TB_RESTAURANT_BOOKMARK
- id — BIGINT
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- restaurant_id — BIGINT — 외래 키 → TB_RESTAURANT.id — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_user_id
- INDEX — idx_restaurant_id
TB_RESTAURANT_PHOTO
- id — BIGINT
- restaurant_id — BIGINT — 외래 키 → TB_RESTAURANT.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- source — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- INDEX — idx_restaurant_id
TB_REVIEW
- id — BIGINT
- restaurant_id — BIGINT — 외래 키 → TB_RESTAURANT.id — NOT NULL
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- company_id — BIGINT — 외래 키 → TB_COMPANY.id — NOT NULL
- rating — INT — NOT NULL
- content — TEXT
- recommended_menu — VARCHAR(255)
- is_anonymous — BOOLEAN
- created_at — DATETIME — NOT NULL
- INDEX — idx_restaurant_id
- INDEX — idx_user_id
- INDEX — idx_company_id
TB_REVIEW_LIKE
- id — BIGINT
- review_id — BIGINT — 외래 키 → TB_REVIEW.id — NOT NULL
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_review_id
- INDEX — idx_user_id
TB_REVIEW_PHOTO
- id — BIGINT
- review_id — BIGINT — 외래 키 → TB_REVIEW.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_review_id
TB_REVIEW_REPORT
- id — BIGINT
- review_id — BIGINT — 외래 키 → TB_REVIEW.id — NOT NULL
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- reason — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- INDEX — idx_review_id
- INDEX — idx_user_id
TB_USER
- id — BIGINT
- company_id — BIGINT — 외래 키 → TB_COMPANY.id — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100)
- role — VARCHAR(50) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_company_id
TB_USER_PROFILE_IMAGE
- id — BIGINT
- user_id — BIGINT — 외래 키 → TB_USER.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_user_id