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