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