sol metting

Tables (8)

ADDRESS (Untitled7)

  • ADDRESS_ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Long — Foreign key → USER.USER_ID — NOT NULL
  • SI (Field) — VARCHAR
  • GU (Field2) — VARCHAR

BLOCKED (Untitled6)

  • BLOCKED_ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Foreign key → USER.USER_ID — NOT NULL
  • USER_ID (Field) — LONG
  • TARGET_ID (Field2) — LONG

CHATROOM (Untitled4)

  • ROOM_ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Foreign key → USER.USER_ID — NOT NULL
  • USER1_ID (Field) — LONG
  • USER2_ID (Field2) — LONG
  • USER1_ATTEND (Field3) — BOOL
  • USER2_ATTEND (Field4) — BOOL

IMAGE (Untitled2)

  • IMAGE_ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Foreign key → USER.USER_ID — NOT NULL
  • IMAGE_URL (Field) — VARCHAR

INTEREST (Untitled3)

  • INTEREST_ID (Key) — Primary key — NOT NULL
  • USER_ID (Key2) — Long — Foreign key → USER.USER_ID — NOT NULL
  • INTERST (Field) — ENUM

MATCH_POOL (Untitled8)

  • MATCH_ID (Key) — Primary key — NOT NULL
  • USER1_ID (Field) — LONG
  • USER2_ID (Field2) — LONG
  • USER1_ACCEPT (Field3) — BOOL
  • USER2_ACCEPT (Field4) — BOOL
  • MACHTED (Field5) — BOOL
  • USER_ID (Key2) — LONG — Foreign key → USER.USER_ID — NOT NULL

MESSAGE (Untitled5)

  • MESSAGE_ID (Key) — Primary key — NOT NULL
  • ROOM_ID (Key2) — Foreign key → CHATROOM.ROOM_ID — NOT NULL
  • USER_ID (Key22) — Foreign key → CHATROOM.USER_ID — NOT NULL
  • USER2_ID (Field) — LONG
  • CONTENT (Field2) — VARCHAR
  • TIMESTEAMP (Field3) — DATETIME

USER (Untitled)

  • USER_ID (Key) — Long — Primary key — NOT NULL
  • EMAIL (Field) — EMail
  • CREATED_AT (Field2) — DATE
  • UPDATED_AT (Field3) — DATE
  • DELETED_AT (Field4) — DATE
  • ROLE (Field5) — ENUM
  • BIRTH (Field6) — VARCHAR
  • GENDER (Field7) — ENUM
  • DRINK (Field8) — ENUM
  • SMOKING (Field9) — ENUM
  • EXERCISE (Field10) — ENUM
  • PET (Field11) — ENUM
  • CONTACT (Field12) — ENUM
  • LAST_EDUCATION (Field13) — ENUM
  • ADDRESS_ID (Field14) — LONG
  • MBTI (Field15) — ENUM
  • ECONOMIC_SCORE (Field16) — Integer
  • MATCH_ENABLE (Field17) — BOOL