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