CoupleMaker
Tables (6)
tbl_images (Untitled5)
- image_no (Key) — int — Primary key — NOT NULL — auto_increment
- image (Field) — NOT NULL
- user_no (Key2) — varchar(300) — Foreign key → tbl_user.user_no — NOT NULL — uuid
tbl_interest (Untitled3)
- interest_no (Key) — varchar(300) — Primary key — NOT NULL — uuid
- interest (Field) — varchar(300) — NOT NULL
- category (Field2) — varchar(200) — NOT NULL
- user_no (Key2) — varchar(300) — Foreign key → tbl_user.user_no — NOT NULL — uuid
tbl_oto_chat (Untitled2)
- chat_no (Key) — int — Primary key — NOT NULL
- room_no (Field2) — int — NOT NULL
- content (Field3) — varchar(500) — NOT NULL
- date (Field4) — datetime — NOT NULL
- writer (Key2) — varchar(300) — Foreign key → tbl_user.user_no — NOT NULL — uuid
- like (Field) — tinyint(1) — NOT NULL
tbl_relation (Untitled4)
- active_user_no (Key) — varchar(300) — Foreign key → tbl_user.user_no — NOT NULL — multi_column_unique, uuid
- passive_user_no (Key2) — varchar(300) — Foreign key → tbl_user.user_no — NOT NULL — multi_column_unique, uuid
- relation_type (Field) — varchar(300) — NOT NULL — multi_column_unique
tbl_report (Untitled6)
- report_no (Key) — int — Primary key — NOT NULL — auto_increment
- reason (Field) — varchar(300)
- type (Field2) — varchar(100) — NOT NULL
- user_no (Key2) — varchar(300) — Foreign key → tbl_user.user_no — NOT NULL — uuid
- reported_user_no (Key3) — varchar(300) — Foreign key → tbl_user.user_no — NOT NULL — uuid
tbl_user (Untitled)
- user_no (Key) — varchar(300) — Primary key — NOT NULL — uuid
- email (Field) — varchar(30) — NOT NULL
- password (Field2) — varchar(100) — NOT NULL
- refresh_token (Field3) — varchar(200)
- name (Field4) — varchar(50) — NOT NULL
- authority (Field5) — varchar(50) — NOT NULL
- reg_date (Field6) — datetime — NOT NULL — current_timestamp
- address (Field7) — varchar(100)
- gender (Field8) — int — NOT NULL
- job (Field9) — varchar(100)
- profile_img (Field10) — varchar(300)
- born_date (Field11) — date_time
- mbti (Field12) — varchar(30)
- refresh_exp_date (Field13) — datetime
- score (Field14) — decimal(3,2)