M&M_ERD
Tables (17)
answer
- id — BIGINT(20) — Primary key — NOT NULL
- member_nickname (id2) — BIGINT(20) — Foreign key → member.id
- question_id (id3) — BIGINT(20) — Foreign key → question.id
- create_date — DATETIME(6)
- delete_date — DATETIME(6)
- modify_date — DATETIME(6)
- content — TEXT
answer_vote
- id — INT(11) — Primary key — NOT NULL
- member_nickname (id2) — BIGINT(20) — Foreign key → member.id
- answer_id (id3) — BIGINT(20) — Foreign key → answer.id
chat_message
- id — BIGINT(20) — Primary key — NOT NULL
- writer_id (id2) — BIGINT(20) — Foreign key → member.id
- create_date — DATETIME(6)
- message — VARCHAR(255)
- room_id — VARCHAR(255)
- writer — VARCHAR(255)
email_verification
- id — BIGINT(20) — Primary key — NOT NULL
- member_id (id2) — BIGINT(20) — Foreign key → member.id — NOT NULL
- expire_date — DATETIME(6)
- code — VARCHAR(255)
emotion_degree
- id — BIGINT(20) — Primary key — NOT NULL
- member_id (id2) — BIGINT(20) — Foreign key → member.id
- magnitude — FLOAT — NOT NULL
- score — FLOAT — NOT NULL
- create_date — DATETIME(6)
- delete_date — DATETIME(6)
- modify_date — DATETIME(6)
- mbti — VARCHAR(255)
likeable_person
- id — BIGINT(20) — Primary key — NOT NULL
- from_member_id (id2) — BIGINT(20) — Foreign key → member.id
- to_member_id (id3) — BIGINT(20) — Foreign key → member.id
- create_date — DATETIME(6)
- delete_date — DATETIME(6)
- modify_date — DATETIME(6)
mbti
- id — BIGINT(20) — Primary key — NOT NULL
- create_date — DATETIME(6)
- delete_date — DATETIME(6)
- modify_date — DATETIME(6)
- best_mbti — VARCHAR(255)
- name — VARCHAR(255)
mbti_answer
- id — BIGINT(20) — Primary key — NOT NULL
- question_id (id2) — BIGINT(20) — Foreign key → mbti_question.id
- member_nickname (id3) — BIGINT(20) — Foreign key → member.id
- create_date — DATETIME(6)
- delete_date — DATETIME(6)
- modify_date — DATETIME(6)
- content — TEXT
mbti_answer_vote
- id — INT(11) — Primary key — NOT NULL
- mbti_answer_id (id2) — BIGINT(20) — Foreign key → mbti_answer.id
- member_nickname (id3) — BIGINT(20) — Foreign key → member.id
mbti_question
- id — BIGINT(20) — Primary key — NOT NULL
- member_nickname (id2) — BIGINT(20) — Foreign key → member.id
- view — INT(11) — NOT NULL
- create_date — DATETIME(6)
- delete_date — DATETIME(6)
- modify_date — DATETIME(6)
- subject — VARCHAR(200)
- content — TEXT
- mbti — VARCHAR(255)
mbti_question_vote
- id — BIGINT(20) — Primary key — NOT NULL
- voter_id (id2) — BIGINT(20) — Foreign key → member.id
- question_id (id3) — BIGINT(20) — Foreign key → mbti_question.id
member
- id — BIGINT(20) — Primary key — NOT NULL
- age — INT(11)
- deleted — BIT(1) — NOT NULL
- email_verified — BIT(1)
- height — INT(11)
- create_date — DATETIME(6)
- delete_date — DATETIME(6)
- modify_date — DATETIME(6)
- email — VARCHAR(255)
- gender — VARCHAR(255)
- hobby — VARCHAR(255)
- introduce — VARCHAR(255)
- locate — VARCHAR(255)
- mbti — VARCHAR(255)
- name — VARCHAR(255)
- nickname — VARCHAR(255)
- password — VARCHAR(255)
- profile_image — VARCHAR(255)
- provider_type — VARCHAR(255)
- username — VARCHAR(255)
notification
- id — BIGINT(20) — Primary key — NOT NULL
- from_member_id (id2) — BIGINT(20) — Foreign key → member.id
- to_member_id (id3) — BIGINT(20) — Foreign key → member.id
- create_date — DATETIME(6)
- delete_date — DATETIME(6)
- modify_date — DATETIME(6)
- read_date — DATETIME(6)
object_file
- id — BIGINT(20) — Primary key — NOT NULL
- url — VARCHAR(255)
question
- id — BIGINT(20) — Primary key — NOT NULL
- member_nickname (id2) — BIGINT(20) — Foreign key → member.id
- view — INT(11) — NOT NULL
- create_date — DATETIME(6)
- delete_date — DATETIME(6)
- modify_date — DATETIME(6)
- subject — VARCHAR(200)
- content — TEXT
question_vote
- id — BIGINT(20) — Primary key — NOT NULL
- voter_id (id2) — BIGINT(20) — Foreign key → member.id
- question_id (id3) — BIGINT(20) — Foreign key → question.id
send_email_log
- id — BIGINT(20) — Primary key — NOT NULL
- create_date — DATETIME(6)
- delete_date — DATETIME(6)
- fail_date — DATETIME(6)
- modify_date — DATETIME(6)
- send_end_date — DATETIME(6)
- body — VARCHAR(255)
- email — VARCHAR(255)
- message — VARCHAR(255)
- result_code — VARCHAR(255)
- subject — VARCHAR(255)