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)