seb44_pre_006

Tables (4)

ANSWER

  • ANSWER_ID (Key) — Not null — Primary key — NOT NULL
  • QUESTION_ID (Key2) — Not null — Foreign key → QUESTION.QUESTION_ID — NOT NULL
  • MEMBER_ID (member_id) — Not null — Foreign key → MEMBER.MEMBER_ID
  • CONTENT (Field) — Not null
  • CREATED_AT (Field2) — Not null
  • MODIFIED_AT (Field3) — Not null

MEMBER

  • MEMBER_ID (member_id) — Not null — Primary key
  • EMAIL (email) — Not null
  • PASSWORD (password) — Not null
  • NAME (name) — Not null
  • CREATED_AT (created_at) — Not null
  • MODIRIED_AT (modified_at) — Not null

MEMBER_ROLES

  • MEMBER_MEMBER_ID (member_id) — Not null — Primary key — NOT NULL
  • MEMBER_ID (member_id2) — Not null — Foreign key → MEMBER.MEMBER_ID
  • ROLES (roles) — Not null

QUESTION

  • QUESTION_ID (Key) — Not null — Primary key — NOT NULL
  • MEMBER_ID (member_id) — Not null — Foreign key → MEMBER.MEMBER_ID
  • TITLE (Field) — Not null
  • CONTENT (Field2) — Not null
  • VIEW_COUNT (Field4) — Not null
  • MEMBER_ID (Field5) — Not null
  • CREATED_AT (Field6) — Not null
  • MODIFIED_AT (Field7) — Not null