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