MCNC-ERD

Tables (5)

Answer

  • id — BIGINT — Primary key — NOT NULL
  • createDate — TIMESTAMP
  • response — TEXT
  • queryId — BIGINT — Foreign key → Question.queryId — NOT NULL
  • answer_exampleIndex — INT

Option

  • exampleIndex — INT — Primary key — NOT NULL
  • queryId — BIGINT — Foreign key → Question.queryId — NOT NULL
  • content — TEXT
  • createDate — TIMESTAMP

Question

  • queryId — BIGINT — Primary key — NOT NULL
  • surveyId — BIGINT — Foreign key → Survey.surveyId — NOT NULL
  • question — TEXT
  • type — VARCHAR(10)
  • createDate — TIMESTAMP

Survey

  • surveyId — BIGINT — Primary key — NOT NULL
  • userId — VARCHAR(255) — Foreign key → User.userId — NOT NULL
  • createDate — TIMESTAMP
  • expireDate — TIMESTAMP

User

  • userId — VARCHAR(255) — Primary key — NOT NULL
  • password — VARCHAR(255)
  • gender — CHAR(1)
  • age — INT
  • email — VARCHAR(255)
  • phone — VARCHAR(11)
  • createDate — TIMESTAMP