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