procope_member
Tables (6)
Field (Untitled2)
- field_id (Key) — long — Primary key — NOT NULL
- name (Field) — text
- role_id (Key2) — long — Foreign key → Role.role_id — NOT NULL
MemberFields (Untitled3)
- member_fields_id (Key2) — long — Primary key — NOT NULL
- member_id (2) — long — Foreign key → User.member_id — NOT NULL
- field_id (Key) — long — Foreign key → Field.field_id — NOT NULL
Preference (Untitled5)
- preference_id (Key2) — long — Primary key — NOT NULL
- value (Field) — int
- member_id (2) — long — Foreign key → User.member_id — NOT NULL
- question_id (Key) — long — Foreign key → Questions.question_id — NOT NULL
Questions (Untitled4)
- question_id (Key) — long — Primary key — NOT NULL
- contents (Field) — text
- is_active (Field2) — boolean
- parent_question_id (Key2) — long — Foreign key → Questions.question_id — NOT NULL
Role (Untitled)
- role_id (Key) — long — Primary key — NOT NULL
- name (Field) — text
User (Member)
- member_id — long — Primary key — NOT NULL
- name (Field2) — text
- role_id (Key) — long — Foreign key → Role.role_id — NOT NULL