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