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