erd0710
Tables (36)
activity_action_types
- code — VARCHAR(30)
activity_scores
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- region_id — BIGINT
- source_type_code — VARCHAR(30) — NOT NULL
- action_type_code — VARCHAR(30) — NOT NULL
- related_id — BIGINT
- point — INT — NOT NULL
- is_approved — BOOLEAN
- approved_by — BIGINT
- earned_at — DATETIME — NOT NULL
- expires_at — DATETIME
activity_source_types
- code — VARCHAR(30)
admin_profiles
- id — BIGINT
- user_id — BIGINT — NOT NULL
- role_code — VARCHAR(30) — NOT NULL
- department — VARCHAR(100)
- phone — VARCHAR(30)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
admin_roles
- code — VARCHAR(30)
- name — VARCHAR(50) — NOT NULL
certification_statuses
- code — VARCHAR(20)
comments
- id — BIGINT
- post_id — BIGINT — NOT NULL
- user_id — BIGINT
- content — TEXT — NOT NULL
- parent_id — BIGINT
- is_deleted — BOOLEAN
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
community_activity_logs
- id — BIGINT
- action_code — VARCHAR(20) — NOT NULL
- target_post_id — BIGINT
- target_comment_id — BIGINT
- description — TEXT
- created_at — DATETIME — NOT NULL
- user_id — BIGINT
- region_id — BIGINT
interaction_actions
- code — VARCHAR(30)
- name — VARCHAR(50)
mentor_certification_requests
- id — BIGINT
- user_id — BIGINT — NOT NULL
- document_url — TEXT — NOT NULL
- status_code — VARCHAR(20)
- reviewed_by — BIGINT
- reviewed_at — DATETIME
- rejection_reason — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
mentor_income_logs
- id — BIGINT
- user_id — BIGINT — NOT NULL
- month — VARCHAR(7) — NOT NULL
- level_code — VARCHAR(30) — NOT NULL
- activity_score — INT — NOT NULL
- weight_multiplier — FLOAT — NOT NULL
- calculated_ratio — FLOAT — NOT NULL
- payout_amount — INT — NOT NULL
- is_paid — BOOLEAN
- paid_at — DATETIME
- created_at — DATETIME — NOT NULL
mentor_levels
- code — VARCHAR(30)
- name — VARCHAR(50) — NOT NULL
mentor_profiles
- id — BIGINT
- user_id — BIGINT — NOT NULL
- region_id — BIGINT
- level_code — VARCHAR(30)
- level_acquired_at — DATETIME
- current_score — INT
- warning_count — INT
- is_certified_by_public — BOOLEAN
- is_active — BOOLEAN
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
mentor_promotions
- id — BIGINT
- user_id — BIGINT — NOT NULL
- region_id — BIGINT
- promotion_level_code — VARCHAR(30) — NOT NULL
- approved_by — BIGINT
- promoted_at — DATETIME — NOT NULL
- note — TEXT
messages
- id — BIGINT
- sender_id — BIGINT
- receiver_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- sent_at — DATETIME — NOT NULL
notification_target_types
- code — VARCHAR(30)
notification_types
- code — VARCHAR(30)
- description — VARCHAR(100)
notifications
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- alert_type_code — VARCHAR(30) — NOT NULL
- target_type_code — VARCHAR(30) — NOT NULL
- target_id — BIGINT — NOT NULL
- is_read — BOOLEAN
- read_at — DATETIME
- sent_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
policies
- id — BIGINT
- title — VARCHAR(200) — NOT NULL
- summary — TEXT — NOT NULL
- category_code — VARCHAR(30) — NOT NULL
- support_amount — INT — NOT NULL
- deadline — DATE
- external_url — TEXT
- is_deleted — BOOLEAN
- region_id — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
policy_categories
- code — VARCHAR(30)
- name — VARCHAR(100) — NOT NULL
policy_favorites
- user_id — BIGINT — Primary key — NOT NULL
- policy_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
policy_interaction_logs
- id — BIGINT
- policy_id — BIGINT
- user_id — BIGINT
- action_code — VARCHAR(30) — NOT NULL
- platform — ENUM('WEB', 'MOBILE')
- detail — JSON
- created_at — DATETIME — NOT NULL
post_like_types
- id — TINYINT
- code — VARCHAR(20) — NOT NULL
- label — VARCHAR(50) — NOT NULL
post_likes
- user_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Primary key — NOT NULL
- like_type_id — TINYINT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
posts
- id — BIGINT
- user_id — BIGINT — NOT NULL
- region_id — BIGINT
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- tag — VARCHAR(50)
- likes — INT
- views — INT
- is_notice — BOOLEAN
- is_mentor_only — BOOLEAN
- is_deleted — BOOLEAN
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
recommendation_logs
- id — BIGINT
- recommendation_type_code — VARCHAR(30) — NOT NULL
- target_id — BIGINT — NOT NULL
- score — FLOAT — NOT NULL
- reason — TEXT
- algorithm_version — VARCHAR(20)
- ab_test_group — VARCHAR(50)
- experiment_name — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- user_id — BIGINT
recommendation_types
- code — VARCHAR(30)
regions
- id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- level — ENUM('SIDO', 'SIGUNGU', 'EUPMYEONDONG') — NOT NULL
- parent_id — BIGINT
- timezone — VARCHAR(50)
- country_code — VARCHAR(3)
report_reasons
- code — VARCHAR(20)
- description — VARCHAR(100)
reports
- id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- target_type_code — VARCHAR(30) — NOT NULL
- target_id — BIGINT — NOT NULL
- reason_code — VARCHAR(20) — NOT NULL
- reason_detail — TEXT
- created_at — DATETIME — NOT NULL
- review_result_code — VARCHAR(20)
- reviewed_at — DATETIME
- reviewed_by — BIGINT
review_results
- code — VARCHAR(20)
- description — VARCHAR(100)
roles
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(100)
search_query_logs
- id — BIGINT
- keyword — VARCHAR(100)
- category_code — VARCHAR(30)
- region_id — BIGINT
- result_count — INT
- search_source — ENUM('HOME', 'COMMUNITY', 'POLICY', 'RECOMMEND')
- device_type — VARCHAR(30)
- session_id — VARCHAR(100)
- searched_at — DATETIME — NOT NULL
- user_id — BIGINT
user_roles
- user_id — BIGINT — Primary key — NOT NULL
- role_id — BIGINT — Primary key — NOT NULL
- assigned_at — DATETIME — NOT NULL
user_types
- code — VARCHAR(20)
- name — VARCHAR(50) — NOT NULL
users
- id — BIGINT
- email — VARCHAR(100) — NOT NULL — AES256 암호화 전제
- password — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- age — VARCHAR(20)
- is_social — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- deleted_at — DATETIME
- user_type_code — VARCHAR(20) — NOT NULL