MangoERD

Tables (15)

base_entities

  • create_user — BIGINT
  • created_at — TIMESTAMP
  • update_user — BIGINT
  • updated_at — TIMESTAMP

blocks

  • block_id — BIGINT — Primary key
  • from_id — BIGINT — Foreign key → users.user_id
  • to_id — BIGINT — Foreign key → users.user_id

consumption_ cateogry (소비패턴과 카테고리 간 연관관계 표현)

  • consumption_category_id — BIGINT — Primary key — NOT NULL
  • sub_code (sub_code2) — VARCHAR(30) — Foreign key → sub_code.sub_code
  • pattern_id (pattern_id2) — BIGINT — Foreign key → consumption_patterns.pattern_id

consumption_patterns

  • pattern_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • primary_category — ENUM("스포츠형", "미디어형", "핫플형",.....)
  • secondary_category — ENUM("야구","축구", "클라이밍","OTT","영화관",.....)
  • analysis_period_start — DATE — NOT NULL
  • analysis_period_end — DATE — NOT NULL

main_code

  • main_code — VARCHAR(20) — Primary key
  • main_code_name — VARCHAR(100) — NOT NULL
  • main_code_description — VARCHAR(1000)
  • use_yn — BOOLEAN

mangos

  • like_id — BIGINT — Primary key
  • from_id — BIGINT — Foreign key → users.user_id
  • to_id — BIGINT — Foreign key → users.user_id

matches

  • match_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id

notifications

  • notification_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • notification_type — VARCHAR(30) — Foreign key → sub_code.sub_code
  • title — VARCHAR(100) — NOT NULL
  • message — TEXT — NOT NULL
  • reference_id — BIGINT
  • is_read — BOOLEAN

payment_history

  • payment_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • primary_category — VARCHAR(30) — Foreign key → sub_code.sub_code
  • secondary_category — VARCHAR(30) — Foreign key → sub_code.sub_code
  • price — BIGINT — NOT NULL
  • payment_date — TIMESTAMP — NOT NULL

photos (user_photos)

  • photo_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • photo_url — VARCHAR(500) — NOT NULL
  • photo_order — TINYINT

sub_code

  • sub_code — VARCHAR(30) — Primary key
  • main_code — VARCHAR(20) — Foreign key → main_code.main_code
  • sub_code_name — VARCHAR(100) — NOT NULL
  • sub_code_description — VARCHAR(1000)
  • level — TINYINT — 1:대분류, 2:소분류
  • parent_code — VARCHAR(30)
  • sort_order — INT
  • use_yn — BOOLEAN

survey_answers

  • answer_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • question_id — BIGINT — Foreign key → survey_questions.question_id
  • sub_code — VARCHAR(30) — Foreign key → survey_questions.survey_category
  • answer_value — boolean — NOT NULL — 긍정,부정

survey_questions

  • question_id — BIGINT — Primary key
  • survey_category — VARCHAR(30) — Foreign key → sub_code.sub_code
  • question_text — TEXT — NOT NULL
  • question_order — TINYINT

users

  • user_id — BIGINT — Primary key
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • birth_date — DATE — NOT NULL
  • gender — ENUM('MALE', 'FEMALE') — NOT NULL
  • location — POINT
  • location_address — VARCHAR(255)
  • profile_image_url — VARCHAR(500)
  • introduction — TEXT
  • last_login_at — TIMESTAMP
  • age — TINYINT

visited

  • visited_id — BIGINT — Primary key — NOT NULL
  • from_id — BIGINT — Foreign key → users.user_id
  • to_id — BIGINT — Foreign key → users.user_id