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