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)