Realmate

Tables (6)

ans (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key4) — int — Foreign key → users.id — NOT NULL
  • q_id (Key2) — int — Foreign key → q_both_numer.id — NOT NULL
  • ans_me (Field) — float
  • ans_you (Field2) — float
  • Field3

chat_header (Untitled4)

  • id (Key2) — int — Primary key — NOT NULL
  • user_id (Key42) — int — Foreign key → users.id — NOT NULL
  • user_id_you (Key4) — int — Foreign key → users.id — NOT NULL
  • subject (Field4) — varchar(20)
  • status (Field5) — ENUM
  • time (Field6) — timestamp

message (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • chat_header_id (Key2) — int — Foreign key → chat_header.id — NOT NULL
  • header_id (Field2)
  • read (Field3)
  • time (Field4)
  • is_from_sender (Field)

q_both_numer (양측질문_수치형)

  • id (Key) — Primary key — NOT NULL
  • question (Field)
  • cond1 (Field2)
  • cond2 (Field3)
  • options (Field4)
  • q_type (Field5) — int

user_filter (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key4) — int — Foreign key → users.id — NOT NULL
  • height_me (Field8) — int
  • height_from (Field2) — int
  • height_to (Field12)
  • age_me (Field3) — int
  • age_you_from (Field9) — int
  • age_you_to (Field10)
  • radius (Field4) — int
  • sex_me (Field11) — varchar(20)
  • sex_you (Field5) — varchar(20)
  • about_me (Field) — text
  • about_you (Field7) — text

users (Untitled)

  • id (Key4) — int — Primary key — NOT NULL
  • nickname (Field)
  • email (Field3) — varchar(10)