side

Tables (15)

Untitled (reply)

  • Key (id) — notnull — Primary key — NOT NULL
  • id (user_id) — notnull — Foreign key → user.id — NOT NULL
  • id (survey_id) — notnull — Foreign key → survey.id — NOT NULL

Untitled (answer)

  • Key (id) — notnull — Primary key — NOT NULL
  • Key (reply_id) — notnull — Foreign key → Untitled.Key — NOT NULL
  • id (question_id) — notnull — Foreign key → question.id — NOT NULL
  • Key (question_item_id) — null — Foreign key → Untitled.Key — NOT NULL
  • Field (response) — null

Untitled (file)

  • Key (id) — notnull — Primary key — NOT NULL
  • id (user_id) — notnull — Foreign key → user.id — NOT NULL
  • Field (table_pk) — notnull
  • Field (table_name) — notnull
  • Field (origin_name) — notnull
  • Field (dir) — notnull
  • Field (name) — notnull
  • Field (path) — notnull
  • Field (ext) — notnull

Untitled (point)

  • Key (id) — notnull — Primary key — NOT NULL
  • id (user_id) — notnull — Foreign key → user.id — NOT NULL
  • Field (value) — notnull
  • Field (reason) — notnull
  • Field (table_pk) — nullable
  • Field (table_name) — nullable

Untitled (logged_in)

  • Key (id) — notnull — Primary key — NOT NULL
  • id (user_id) — notnull — Foreign key → user.id — NOT NULL
  • Field (remote_addr) — notnull

Untitled (experience)

  • Key (id) — notnull — Primary key — NOT NULL
  • id (user_id) — notnull — Foreign key → user.id — NOT NULL
  • Field (value) — notnull
  • Field (reason) — notnull
  • Field (table_pk) — nullable
  • Field (table_name) — nullable

Untitled (grade)

  • Key (id) — notnull — Primary key — NOT NULL
  • Field (pivot) — notnull
  • Field (name) — notnull

Untitled (hashtag)

  • Key (id) — notnull — Primary key — NOT NULL
  • Field (value) — notnull

Untitled (hashtag_survey)

  • Key (id) — notnull — Primary key — NOT NULL
  • id (survey_id) — notnull — Foreign key → survey.id — NOT NULL
  • Key (hashtag_id) — notnull — Foreign key → Untitled.Key — NOT NULL

Untitled (section)

  • Key (id) — notnull — Primary key — NOT NULL
  • id (survey_id) — notnull — Foreign key → survey.id — NOT NULL
  • Field (title) — nullable
  • Field (content) — nullable
  • Field (next_section) — nullable

Untitled (pk_manager)

  • Key (id) — notnull — Primary key — NOT NULL
  • Field (table_name) — notnull
  • Field (prefix) — notnull
  • Field (yy) — notnull
  • Field (mm) — notnull
  • Field (dd) — notnull
  • Field (alpha) — notnull
  • Field (count) — notnull

Untitled (question_item)

  • Key (id) — notnull — Primary key — NOT NULL
  • id (question_id) — notnull — Foreign key → question.id — NOT NULL
  • Field (content) — notnull
  • Field (oder) — notnull
  • Field (next_section) — nullable
  • Field (is_end) — notnull

question

  • id — notnull — Primary key — NOT NULL
  • Key (section_id) — notnull — Foreign key → Untitled.Key — NOT NULL
  • Field (ask) — notnull
  • Field (descript) — nullable
  • Field (oder) — notnull
  • Field (multi_fl) — notnull
  • Field (dupl_fl) — notnull
  • Field (ess_fl) — notnull
  • Field (random_show_fl) — notnull
  • Field (explain) — null

survey

  • id — notnull — Primary key — NOT NULL
  • id (user_id) — notnull — Foreign key → user.id — NOT NULL
  • Field (subject) — notnull
  • Field (content) — notnull
  • Field (minute) — notnull
  • Field (start_date) — notnull
  • Field (end_date) — notnull
  • Field (open_fl) — notnull
  • Field (temp_fl) — notnull
  • Field (closing_comment) — notnull
  • Field (pull_date) — nullable

user

  • id — notnull — Primary key — NOT NULL
  • Key (grade_id) — notnull — Foreign key → Untitled.Key — NOT NULL
  • Field (email) — notnull
  • Field (pwd) — notnull
  • Field (gender) — notnull
  • Field (age) — notnull
  • Field (tel) — notnull