USER_DB
Tables (10)
alarm
- alarm_id — UUID — NOT NULL — PK, auto_increment
- user_id — UUID — NOT NULL
- alarm_type — ENUM — NOT NULL
- created_dt — datetime — NOT NULL
- read — boolean — NOT NULL
- content — text — NOT NULL
- sent_user — UUID
alarm_info
- event_id — UUID — Primary key — NOT NULL
- event_content — varchar(200) — NOT NULL
- event_type — varchar(30) — NOT NULL — match, request, chat
alarm_receive_info
- user_id — VARCHAR(255) — Primary key — NOT NULL
- event_id2 — UUID — Foreign key → alarm_info.event_id — NOT NULL
- read_yn — VARCHAR(255) — NOT NULL
block_list
- block_id — VARCHAR(255) — Primary key — NOT NULL — PK, 아이디복합키
- blocking_id — UUID — NOT NULL — FK1
- blocked_id — UUID — NOT NULL — FK2
- block_dt — datetime — NOT NULL
detail_show
- user_id — UUID — Foreign key → user.user_id — NOT NULL — PK
- birth_date_fl — boolean — NOT NULL
- pet_fl — boolean
- allergies_fl — boolean
- mbti_fl — boolean
- movie_fl — boolean
- music_fl — boolean
- workout_fl — boolean
- politic_fl — boolean
- diet_fl — boolean
- location_fl — boolean — 주소 등록->api / GPS로 구글 API 거리 계산...!
- work_fl — boolean
- education_fl — boolean
- hobby_fl — boolean — 최대 3개
- weight_fl — boolean
invisible_attr
- sealed_id — VARCHAR(255) — Primary key — NOT NULL
- user_no — VARCHAR(255) — NOT NULL
- attr — VARCHAR(255)
like
- like_id — VARCHAR(255) — Primary key — NOT NULL — PK, 아이디 복합키
- liking_id — UUID — NOT NULL — FK1
- liked_id — UUID — NOT NULL — FK2
- like_dt — datetime — NOT NULL
preference
- user_id — UUID — Foreign key → user.user_id — NOT NULL — PK
- gender — char — NOT NULL
- age — VARCHAR — NOT NULL — YYYYMMDD
- looking_for — VARCHAR — NOT NULL
- language — VARCHAR
- pet — VARCHAR
- allergies — VARCHAR
- mbti — VARCHAR
- movie — VARCHAR
- music — VARCHAR
- workout — VARCHAR
- politic — ENUM
- education — varchar
- diet — VARCHAR
- height — DOUBLE
- religion — varchar
- smoking — varchar
- drinking — varchar
user
- user_id — UUID — Primary key — NOT NULL — PK, auto_increment
- email — VARCHAR — NOT NULL
- type — ENUM
- name — VARCHAR — NOT NULL
- created_dt — datetime — NOT NULL
- updated_dt — datetime
- user_st — ENUM — NOT NULL
user_detail
- user_id — UUID — Primary key — NOT NULL — PK
- nickname — VARCHAR — NOT NULL
- bio — LONGTEXT — NOT NULL
- gender — char — NOT NULL
- birth_ymd — VARCHAR — NOT NULL — YYYYMMDD
- photo — LONGTEXT — NOT NULL — 경로 배열로 저장. 0이 메인 사진
- looking_for — VARCHAR — NOT NULL
- height — DOUBLE — NOT NULL
- religion — varchar — NOT NULL
- smoking — varchar — NOT NULL
- hobby — VARCHAR — NOT NULL — 최대 3개 직접 입력. 배열로 저장
- drinking — varchar — NOT NULL
- language — VARCHAR — NOT NULL
- pet — VARCHAR
- allergies — VARCHAR
- mbti — VARCHAR
- movie — VARCHAR
- music — VARCHAR
- workout — VARCHAR
- politic — ENUM
- diet — VARCHAR
- weight — DOUBLE
- location — TEXT — 주소 등록하게 할지->api / GPS로 구글 API 거리 계산...!
- work — varchar
- education — varchar