QnA Crud
Tables (5)
Answer (Untitled3)
- AnswerID (PK) — INT — Primary key — NOT NULL
- QuestionID (FK) — INT — Foreign key → Question.QuestionID — NOT NULL
- MEMBER_ID (FK2) — INT — Foreign key → Question.MEMBER_ID — NOT NULL
- MEMBER_ID (PK2) — INT — Foreign key → Member.MEMBER_ID — NOT NULL
- Content (Field) — TEXT
- PostDate (Field2) — DATETIME
Like (Untitled4)
- LikeID (PK) — INT — Primary key — NOT NULL
- QuestionID (PK2) — INT — Foreign key → Question.QuestionID — NOT NULL
- MEMBER_ID (FK) — INT — Foreign key → Question.MEMBER_ID — NOT NULL
- LikeDate (Field) — DATETIME
Member (Untitled)
- MEMBER_ID (PK) — INT — Primary key — NOT NULL
- CREATED_AT (f) — DATETIME
- LAST_MODIFIED_AT (Field2) — DATETIME
- EMAIL (VARCHAR) — VARCHAR
- MEMBER_STATUS (Field)
- NAME (Field4) — VARCHAR
- PHONE (Field5)
Question (Untitled2)
- QuestionID (PK) — INT — Primary key — NOT NULL
- MEMBER_ID (FK) — INT — Foreign key → Member.MEMBER_ID — NOT NULL
- Title (Field) — VARCHAR
- Content (Field2) — TEXT
- PostDate (Field3) — DATETIME
- Status (Field4) — ENUM
- Visibility (Field5) — ENUM
View (Untitled5)
- ViewID (PK) — INT — Primary key — NOT NULL
- QuestionID (PK2) — INT — Foreign key → Question.QuestionID — NOT NULL
- MEMBER_ID (FK) — INT — Foreign key → Question.MEMBER_ID — NOT NULL
- ViewDate (Field) — DATETIME