a
Tables (7)
veri_notification (Untitled2)
- noti_id (PK) — Primary key — NOT NULL
- value_id (PK2) — Foreign key → veri_value_group.value_id — NOT NULL
- push_title (Field) — CHAR(30)
- push_content (Field2) — CHAR(60)
- app_title (Field3) — CHAR(60)
- app_content (Field4) — CHAR(500)
- sequence (Field5) — INT
veri_notificatoin_group (Untitled7)
- noti_id (PK) — Foreign key → veri_notification.noti_id — NOT NULL
- group_id (Field)
veri_performance (Untitled5)
- id (Key) — Primary key — NOT NULL
- uid (FK) — Foreign key → veri_users.uid — NOT NULL
- group_id (FK1) — Foreign key → veri_users.group_id — NOT NULL
- date (Field) — DATETIME
- performance (Field2) — INT
veri_user_noti (Untitled6)
- uid (FK) — Foreign key → veri_users.uid — NOT NULL
- noti_id (FK2) — Foreign key → veri_notification.noti_id — NOT NULL
- noti_date (Field) — DATETIME
veri_users (Untitled)
- uid (PK) — Primary key — NOT NULL
- group_id (FK) — Foreign key → veri_value_group.group_id — NOT NULL
- value_id (FK2) — Foreign key → veri_value.value_id — NOT NULL
- nickname (Field) — VARCHAR
- register_at (Field5) — DATETIME
- survey_sent_date (Field4) — DATETIME
- survey_sent_times (Field6) — INT
- survey_response_times (Field7) — DATETIME
- noti_sent_times (Field2) — INT
veri_value (Untitled3)
- value_id (PK) — Primary key — NOT NULL
- value_title (Field) — CHAR
veri_value_group (Untitled4)
- group_id (PK) — Primary key — NOT NULL
- value_id (FK) — Foreign key → veri_value.value_id — NOT NULL
- group_title (Field)