Exxy
Tables (10)
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
- Field — dateTime
ATTENDANCE (Untitled3)
- AT_IDX (Key) — long — Primary key — NOT NULL
- AT_DATE (Field) — dateTime
- AT_STATE (Field2) — int
- AT_MEMO (Field3) — string
- STUDENT_IDX (Key2) — long — Foreign key → STUDENT.STUDENT_IDX — NOT NULL
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 (Key2) — long — Foreign key → ACCOUNT.USER_IDX — NOT NULL
CLASS_DEFAULT_TASK (Untitled8)
- CLASS_DEFAULT_TASK_IDX (Key) — long — Primary key — NOT NULL
- TASK_ITEM_NAME_IDX (Key2) — long — Foreign key → TASK_ITEM_INFO.TASK_ITEM_INFO_IDX — NOT NULL
- CLASS_IDX (Key3) — long — Foreign key → CLASS.CLASS_IDX — NOT NULL
REPORT_CARD (Untitled7)
- STUDENT_IDX (Key1) — long — Foreign key → STUDENT.STUDENT_IDX — NOT NULL
- REPOCARD_COMMENT (Field) — string
- REPOCARD_CHECKLIST (Field2) — string
SECTION (Untitled5)
- SECTION_IDX (Key) — long — Primary key — NOT NULL
- SECTION_NAME (Field) — string
- CLASS_IDX (Key3) — long — Foreign key → CLASS.CLASS_IDX — NOT NULL
SECTION_ITEM (Untitled10)
- SECTION_ITEM_IDX (Key) — long — Primary key — NOT NULL
- MAX_SCORE (Field2) — double
- SECTION_IDX (Key2) — long — Foreign key → SECTION.SECTION_IDX — NOT NULL
- TASK_ITEM_INFO_IDX (Key22) — long — Foreign key → TASK_ITEM_INFO.TASK_ITEM_INFO_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
TASK_ITEM (Untitled6)
- TASK_ITEM_IDX (Key) — long — Primary key — NOT NULL
- TASK_SCORE (Field2) — double
- STUDENT_IDX (Key4) — long — Foreign key → STUDENT.STUDENT_IDX — NOT NULL
- SECTION_ITEM_IDX (Key3) — long — Foreign key → SECTION_ITEM.SECTION_ITEM_IDX — NOT NULL
TASK_ITEM_INFO (Untitled9)
- TASK_ITEM_INFO_IDX (Key2) — long — Primary key — NOT NULL
- CLASS_GRADE_RATIO (Field2) — long
- TASK_ITEM_INFO (Field) — string
- CLASS_IDX (Key) — long — Foreign key → CLASS.CLASS_IDX — NOT NULL