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