모프2
테이블 (11)
Comments
- commentId — VARCHAR(255)
- userId — VARCHAR(255)
- surveyId — VARCHAR(255)
- text — TEXT — NOT NULL
- createdDate — DATETIME — NOT NULL
Likes
- surveyId — VARCHAR(255)
- userId — VARCHAR(255)
Options
- OptionId — VARCHAR(255)
- QuestionId — VARCHAR(255) — NOT NULL
- Content — VARCHAR(255) — NOT NULL
PointTransactions
- TransactionId — VARCHAR(255)
- UserId — VARCHAR(255) — NOT NULL
- Amount — INT — NOT NULL
- TransactionType — VARCHAR(50) — NOT NULL
- TransactionDate — TIMESTAMP
- ItemId — VARCHAR(255)
Questions
- QuestionId — VARCHAR(255)
- SurveyId — VARCHAR(255) — NOT NULL
- Title — VARCHAR(255) — NOT NULL
- Content — TEXT
- OrderNo — INT — NOT NULL
Responses
- ResponseId — VARCHAR(255)
- UserId — VARCHAR(255) — NOT NULL
- QuestionId — VARCHAR(255) — NOT NULL
- SelectedOption — VARCHAR(255)
- ResponseDate — TIMESTAMP — NOT NULL
StoreItems
- ItemId — VARCHAR(255)
- ItemName — VARCHAR(255) — NOT NULL
- Cost — INT — NOT NULL
- Description — TEXT
SurveyQuestions
- questionId — VARCHAR(255)
- surveyId — VARCHAR(255)
- content — TEXT — NOT NULL
SurveyResults
- surveyId — VARCHAR(255)
- userId — VARCHAR(255)
- questionId — VARCHAR(255)
- response — VARCHAR(255)
Surveys
- SurveyId — VARCHAR(255)
- CreatorId — VARCHAR(255) — NOT NULL
- Title — VARCHAR(255) — NOT NULL
- Content — TEXT
- CreatedDate — TIMESTAMP — NOT NULL
- ModifiedDate — TIMESTAMP — NOT NULL
- Status — VARCHAR(50) — NOT NULL
Users
- UserId — VARCHAR(255)
- Email — VARCHAR(255) — NOT NULL
- Points — INT
- CreatedDate — TIMESTAMP — NOT NULL
- ModifiedDate — TIMESTAMP — NOT NULL
- Status — VARCHAR(50) — NOT NULL