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