ai
Tables (22)
Announcements
- AnnouncementId — VARCHAR(50) — NOT NULL
- SchoolId — VARCHAR(50) — NOT NULL
- SubjectId — VARCHAR(50) — NOT NULL
- ClassId — VARCHAR(50) — NOT NULL
- Title — VARCHAR(255)
- Content — TEXT
- RegDate — DATE
- ModifiedDate — TIMESTAMP
Attachments
- AttachmentId — VARCHAR(50) — NOT NULL
- SchoolId — VARCHAR(50) — NOT NULL
- BoardType — VARCHAR(50)
- BoardKey — VARCHAR(50)
- OriginalName — VARCHAR(255)
- SaveName — VARCHAR(255)
- RegDate — DATE
- ModifiedDate — TIMESTAMP
Calendar
- CalendarId — VARCHAR(50) — NOT NULL
- EventName — VARCHAR(255)
- EventDate — DATE
Classes
- ClassId — VARCHAR(50) — NOT NULL
- SchoolId — VARCHAR(50) — NOT NULL
- Year — INT
- Grade — INT
- InClass — VARCHAR(10)
ClubUsage
- ClubUsageId — VARCHAR(50) — NOT NULL
- UserId — VARCHAR(50) — NOT NULL
- ClubId — VARCHAR(50) — NOT NULL
Clubs
- ClubId — VARCHAR(50) — NOT NULL
- CommunityId — VARCHAR(50) — NOT NULL
- Name — VARCHAR(255)
Comments
- CommentId — VARCHAR(50) — NOT NULL
- UserId — VARCHAR(50) — NOT NULL
- PostId — VARCHAR(50) — NOT NULL
- ParentCommentId — VARCHAR(50)
- Content — TEXT
- LikeCount — INT
- RegDate — DATE
- ModifiedDate — TIMESTAMP
Communities
- CommunityId — VARCHAR(50) — NOT NULL
- Category — VARCHAR(255)
CommunityUsage
- CommunityUsageId — VARCHAR(50) — NOT NULL
- UserId — VARCHAR(50) — NOT NULL
- CommunityId — VARCHAR(50) — NOT NULL
Enrollment
- EnrollmentId — VARCHAR(50) — NOT NULL
- UserId — VARCHAR(50) — NOT NULL
- SubjectId — VARCHAR(50) — NOT NULL
Homework
- HomeworkId — VARCHAR(50) — NOT NULL
- SubjectId — VARCHAR(50) — NOT NULL
- HomeworkSubject — VARCHAR(255)
- HomeworkContent — TEXT
- RegDate — DATE
- ModifiedDate — TIMESTAMP
HomeworkSubmission
- SubmissionId — VARCHAR(50) — NOT NULL
- HomeworkId — VARCHAR(50) — NOT NULL
- UserId — VARCHAR(50) — NOT NULL
- SubmitContent — TEXT
- RegDate — DATE
LectureMaterials
- MaterialId — VARCHAR(50) — NOT NULL
- SubjectId — VARCHAR(50) — NOT NULL
- RegDate — DATE
- ModifiedDate — TIMESTAMP
Meals
- MealId — VARCHAR(50) — NOT NULL
- SchoolId — VARCHAR(50) — NOT NULL
- ATPT_OFCDC_SC_CODE — VARCHAR(50)
- ATPT_OFCDC_SC_NM — VARCHAR(255)
- SD_SCHUL_CODE — VARCHAR(50)
- SCHUL_NM — VARCHAR(255)
- MMEAL_SC_CODE — VARCHAR(10)
- MMEAL_SC_NM — VARCHAR(50)
- MLSV_YMD — DATE
- MLSV_FGR — VARCHAR(50)
- DDISH_NM — VARCHAR(255)
- ORPLC_INFO — VARCHAR(255)
- CAL_INFO — VARCHAR(255)
- NTR_INFO — VARCHAR(255)
- MLSV_FROM_YMD — DATE
- MLSV_TO_YMD — DATE
- LOAD_DTM — VARCHAR(50)
Permissions
- PermissionId — VARCHAR(50) — NOT NULL
- PermissionName — VARCHAR(255)
Posts
- PostId — VARCHAR(50) — NOT NULL
- CommunityId — VARCHAR(50) — NOT NULL
- UserId — VARCHAR(50) — NOT NULL
- Title — VARCHAR(255)
- Content — TEXT
- LikeCount — INT
- RegDate — DATE
- ModifiedDate — TIMESTAMP
QuestionBoard
- QuestionId — VARCHAR(50) — NOT NULL
- SubjectId — VARCHAR(50) — NOT NULL
- QuestionUserId — VARCHAR(50) — NOT NULL
- AnswerUserId — VARCHAR(50) — NOT NULL
- RegDate — DATE
- ModifiedDate — TIMESTAMP
SchoolInformation
- SchoolId — VARCHAR(50) — NOT NULL
- ATPT_OFCDC_SC_CODE — VARCHAR(50)
- ATPT_OFCDC_SC_NM — VARCHAR(255)
- SD_SCHUL_CODE — VARCHAR(50)
- SCHUL_NM — VARCHAR(255)
- ENG_SCHUL_NM — VARCHAR(255)
- SCHUL_KND_SC_NM — VARCHAR(100)
- LCTN_SC_NM — VARCHAR(100)
- JU_ORG_NM — VARCHAR(100)
- FOND_SC_NM — VARCHAR(100)
- ORG_RDNZC — VARCHAR(100)
- ORG_RDNMA — VARCHAR(100)
- ORG_RDNDA — VARCHAR(100)
- ORG_TELNO — VARCHAR(20)
- HMPG_ADRES — VARCHAR(255)
- COEDU_SC_NM — VARCHAR(50)
- ORG_FAXNO — VARCHAR(20)
- HS_SC_NM — VARCHAR(50)
- INDST_SPECL_CCCCL_EXST_YN — VARCHAR(10)
- HS_GNRL_BUSNS_SC_NM — VARCHAR(100)
- SPCLY_PURPS_HS_ORD_NM — VARCHAR(100)
- ENE_BFE_SEHF_SC_NM — VARCHAR(100)
- DGHT_SC_NM — VARCHAR(100)
- FOND_YMD — VARCHAR(10)
- FOAS_MEMRD — VARCHAR(255)
- LOAD_DTM — VARCHAR(50)
StudentParents
- StudentParentId — VARCHAR(50) — NOT NULL
- StudentId — VARCHAR(50) — NOT NULL
- ParentId — VARCHAR(50) — NOT NULL
Subjects
- SubjectId — VARCHAR(50) — NOT NULL
- SchoolId — VARCHAR(50) — NOT NULL
- SubjectName — VARCHAR(100)
UserPermissions
- UserPermissionId — VARCHAR(50) — NOT NULL
- UserId — VARCHAR(50) — NOT NULL
- PermissionId — VARCHAR(50) — NOT NULL
Users
- UserId — VARCHAR(50) — NOT NULL
- SchoolId — VARCHAR(50) — NOT NULL
- ClassId — VARCHAR(50) — NOT NULL
- Password — VARCHAR(255)
- Name — VARCHAR(100)
- Email — VARCHAR(100)
- PhoneNumber — VARCHAR(20)
- Address — VARCHAR(255)
- RegDate — DATE
- ModDate — TIMESTAMP
- Birthdate — DATE
- ApproveState — VARCHAR(50)