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)