ㅇㅇ
Tables (8)
Class
- classNumber — INT — Primary key
- enrolledDate — DATE — NOT NULL
- creationDate — DATE — NOT NULL
- distributionMode — VARCHAR(255) — NOT NULL
- teamMemberNumber — INT — NOT NULL
- managerProfessor — INT — Foreign key → MemberRecord.userID
MemberRecord
- userID — INT — Primary key
- token — VARCHAR(255) — NOT NULL
- isPaidMember — BOOLEAN — NOT NULL
- serverUsage — INT — NOT NULL
- purchaseDate — DATE — NOT NULL
Response
- responseID — INT — Primary key
- responseValue — VARCHAR(255) — NOT NULL
- studentNumber — INT — Foreign key → User.userID
- questionNumber — INT — Foreign key → SurveyQuestion.questionID
Survey
- surveyID — INT — Primary key
- surveyName — VARCHAR(255) — NOT NULL
- creationCost — DECIMAL(10, 2) — NOT NULL
- creationDate — DATE — NOT NULL
- detail — TEXT — NOT NULL
- createdByVendor — INT — Foreign key → Vendor.vendorID
SurveyQuestion
- questionID — INT — Primary key
- questionTitle — VARCHAR(255) — NOT NULL
- questionOptions — TEXT — NOT NULL
- questionDetail — TEXT — NOT NULL
- surveyID — INT — Foreign key → Survey.surveyID
Team
- teamNumber — INT — Primary key
- averageScoreData — INT — NOT NULL
- characteristics — JSON — NOT NULL
- memberCount — INT — NOT NULL
User
- userID — INT — Primary key
- name — VARCHAR(255) — NOT NULL
- affiliation — VARCHAR(255) — NOT NULL
- gender — VARCHAR(10) — NOT NULL
- birthday — DATE — NOT NULL
- accessDate — DATE — NOT NULL
- email — VARCHAR(255) — NOT NULL
- classNumber — INT — Foreign key → Class.classNumber
- teamNumber — INT — Foreign key → Team.teamNumber
Vendor
- vendorID — INT — Primary key
- businessRecordsTable — TEXT — NOT NULL
- contractPeriod — VARCHAR(50) — NOT NULL
- contractScale — DECIMAL(10, 2) — NOT NULL
- contractStatus — VARCHAR(50) — NOT NULL