a
Tables (12)
block
- block_id — long — Primary key — NOT NULL
- from_id — long
- to_id — long
- block_time — datetime(6)
chat
- chat_id — long — Primary key — NOT NULL
- user_match_id — long — Foreign key → user_match.match_id
- message — varchar(2000)
- sender — varchar(255)
- send_time — datetime(6)
- is_checked — tinyint(1)
email_auth
- id — long — Primary key — NOT NULL
- email — varchar(100) — NOT NULL
- auth_token — varchar(36) — NOT NULL
- certification — tinyint(1) — NOT NULL
- expire_date — datetime(6) — NOT NULL
phone_auth
- id — long — Primary key — NOT NULL
- certification — tinyint(1) — NOT NULL
- expire_date — datetime(6) — NOT NULL
- phone — varchar(11) — NOT NULL
- verify_code — varchar(6) — NOT NULL
profile
- id — long — Primary key — NOT NULL
- user_id — long — Foreign key → user.user_id — NOT NULL
- gps_location_info — varchar(100)
- interest — varchar(100)
- hobby — varchar(100)
- intro — varchar(50)
- nickname — varchar(50) — NOT NULL
- mbti — varchar(4)
- birthday — varchar(8) — NOT NULL
- face_verify — tinyint(1) — NOT NULL
- gender — char(1) — NOT NULL
profile_photo
- profile_photo_id — long — Primary key — NOT NULL
- profile_id — long — Foreign key → profile.id
- photo_url — varchar(255)
report
- report_id — long — Primary key — NOT NULL
- count — int
- report_user — long
- update_time — datetime(6)
user
- user_id — long — Primary key — NOT NULL
- access_token — varchar(255)
- email — varchar(100)
- fcm_token — varchar(255)
- password — varchar(255)
- target_token — varchar(255)
- refresh_token — varchar(255)
- phone — varchar(11)
- phone_auth — tinyint(1) — NOT NULL
- email_auth — tinyint(1)
- user_code — binary(16)
user_like
- like_id — long — Primary key — NOT NULL
- like_from_user_id — long — Foreign key → user.user_id — NOT NULL
- like_to_user_id — long — Foreign key → user.user_id — NOT NULL
user_match
- match_id — long — Primary key — NOT NULL
- user_id1 — long — Foreign key → user.user_id
- user_id2 — long — Foreign key → user.user_id
- generate_time — datetime(6)
- pin_to_top — tinyint(1) — NOT NULL
user_roles
- id — long — Primary key — NOT NULL
- user_user_id — long — Foreign key → user.user_id
- roles — varchar(255)