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