Exxy + Admin
Tables (14)
ACCOUNT (Untitled)
- USER_IDX (Key) — long — Primary key — NOT NULL
- USER_EMAIL (Field4) — string
- USER_PW (Field2) — string
- USER_NAME (Field3) — string
- CUR_SEMESTER (Field5) — string
- GRADUATION (Field6) — string
- CREATE_DATE (Field) — dateTime
- AUTHORITY (Field7) — int
- SCHOOL_IDX (Key2) — long — Foreign key → SCHOOL.SCHOOL_IDX — NOT NULL
ATTENDANCE (Untitled3)
- AT_IDX (Key) — long — Primary key — NOT NULL
- AT_DATE (Field) — dateTime
- AT_STATE (Field2) — int
- AT_MEMO (Field3) — string
- AUTH_STUDENT_IDX (Key4) — long — Foreign key → AUTH_STUDENT.AUTH_STUDENT_IDX — NOT NULL
AUTH_CLASS (Untitled15)
- AUTH_CLASS_IDX (Key4) — long — Primary key — NOT NULL
- USER_IDX (Key) — long — Foreign key → ACCOUNT.USER_IDX — NOT NULL
- CLASS_IDX (Key2) — long — Foreign key → CLASS.CLASS_IDX — NOT NULL
- SEASON_IDX (편의) — long — Foreign key → SEASON.SEASON_IDX — NOT NULL
- STATE (Field) — int
AUTH_STUDENT (Untitled14)
- AUTH_STUDENT_IDX (Key4) — long — Primary key — NOT NULL
- USER_IDX (Key2) — long — Foreign key → ACCOUNT.USER_IDX — NOT NULL
- STUDENT_IDX (Key) — long — Foreign key → STUDENT.STUDENT_IDX — NOT NULL
- SEASON_IDX (편의) — long — Foreign key → SEASON.SEASON_IDX — NOT NULL
- STATE (Field) — int
CLASS (Untitled4)
- CLASS_IDX (Key) — long — Primary key — NOT NULL
- CLASS_NAME (Field) — string
- CLASS_SECTION_NAME (Field2) — string
- CLASS_MEMO (Field6) — string
- USER_IDX (필요없음) — long — Foreign key → ACCOUNT.USER_IDX — NOT NULL
- SEASON_IDX (Key4) — long — Foreign key → SEASON.SEASON_IDX — NOT NULL
CLASS_MEMBERS (Untitled11)
- CLASS_MEMBER_IDX (Key) — long — Primary key — NOT NULL
- AUTH_CLASS_IDX (Key4) — long — Foreign key → AUTH_CLASS.AUTH_CLASS_IDX — NOT NULL
- AUTH_STUDENT_IDX (Key42) — long — Foreign key → AUTH_STUDENT.AUTH_STUDENT_IDX — NOT NULL
- STATE (Field) — int
REPORT_CARD (Untitled7)
- AUTH_STUDENT_IDX (Key4) — long — Foreign key → AUTH_STUDENT.AUTH_STUDENT_IDX — NOT NULL
- REPOCARD_COMMENT (Field) — string
- REPOCARD_CHECKLIST (Field2) — string
SCHOOL (Untitled8)
- SCHOOL_IDX (Key) — long — Primary key — NOT NULL
- SCHOOL_NAME (Field) — string
- SCHOOL_INFO (Field2) — string
SCORE (Untitled6)
- SCORE_IDX (Key) — long — Primary key — NOT NULL
- SCORE (Field2) — double
- SECTION_TASK_IDX (Key3) — long — Foreign key → SECTION_TASKS.SECTION_TASKS_IDX — NOT NULL
- AUTH_STUDENT_IDX (Key4) — long — Foreign key → AUTH_STUDENT.AUTH_STUDENT_IDX — NOT NULL
- SECTION_IDX (편의1) — long — Foreign key → SECTION.SECTION_IDX — NOT NULL
- TASK_IDX (편의2) — long — Foreign key → TASK.TASK_IDX — NOT NULL
- CLASS_MEMBER_IDX (Key2) — long — Foreign key → CLASS_MEMBERS.CLASS_MEMBER_IDX — NOT NULL
SEASON (Untitled12)
- SEASON_IDX (Key) — long — Primary key — NOT NULL
- SEASION_NAME (Field) — string
- SCHOOL_IDX (Key2) — long — Foreign key → SCHOOL.SCHOOL_IDX — NOT NULL
SECTION (Untitled5)
- SECTION_IDX (Key) — long — Primary key — NOT NULL
- SECTION_NAME (Field) — string
- AUTH_CLASS_IDX (편의) — long — Foreign key → AUTH_CLASS.AUTH_CLASS_IDX — NOT NULL
SECTION_TASKS (Untitled10)
- SECTION_TASKS_IDX (Key) — long — Primary key — NOT NULL
- MAX_SCORE (Field2) — double
- SECTION_IDX (Key2) — long — Foreign key → SECTION.SECTION_IDX — NOT NULL
- TASK_IDX (Key22) — long — Foreign key → TASK.TASK_IDX — NOT NULL
STUDENT (Untitled2)
- STUDENT_IDX (Key) — long — Primary key — NOT NULL
- STUDENT_NAME (Field) — string
- STUDENT_SEX (Field2) — int
- STUDENT_MEMO (Field3) — string
- USER_IDX (Key2) — long — Foreign key → ACCOUNT.USER_IDX — NOT NULL
- SEASON_IDX (Key3) — long — Foreign key → SEASON.SEASON_IDX — NOT NULL
TASK (Untitled9)
- TASK_IDX (Key2) — long — Primary key — NOT NULL
- CLASS_GRADE_RATIO (Field2) — long
- TASK_INFO (Field) — string
- AUTH_CLASS_IDX (편의) — long — Foreign key → AUTH_CLASS.AUTH_CLASS_IDX — NOT NULL