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)