erp

Tables (11)

Attendances (Untitled5)

  • attend_id (Key) — Primary key — NOT NULL
  • check_in (Field)
  • check_out (Field2)
  • status (Field3)
  • Student_id (Key2) — INT — Foreign key → Student.Student_id — NOT NULL
  • teach_id (Key3) — Foreign key → Teachers.teach_id — NOT NULL

Attitudes (Untitled2)

  • attitude_id (Key) — Primary key — NOT NULL
  • attitude_desc (Field)
  • attitude_date (Field2)
  • Student_id (Key2) — INT — Foreign key → Student.Student_id — NOT NULL
  • teach_id (Key3) — Foreign key → Teachers.teach_id — NOT NULL

Part (Untitled10)

  • 파트 (Key) — var — Primary key — NOT NULL
  • 부서명 (Field)

Repoarts (Untitled3)

  • report_id (Key) — Primary key — NOT NULL
  • socre (Field)
  • subject (Field2)
  • Student_id (Key2) — INT — Foreign key → Student.Student_id — NOT NULL
  • teach_id (Key3) — Foreign key → Teachers.teach_id — NOT NULL

Salary (Untitled9)

  • 코드 (Key) — var — Primary key — NOT NULL
  • 월급 (Field) — bigint
  • 사번 (Key2) — int — Foreign key → worker.사번 — NOT NULL

Socre (Untitled7)

  • 코드 (Key) — INT — Primary key — NOT NULL
  • 점수 (Field) — DBL
  • 과목 (Field2) — var
  • 코드 (Key2) — INT — Foreign key → Student.코드 — NOT NULL

Student (Untitled)

  • Student_id (Key) — INT — Primary key — NOT NULL
  • name (Field)
  • phone (Field2)
  • age (Field3)
  • gender (Field4)
  • addr (Field5)
  • phone2 (Field6)
  • consult (Field13)
  • status (Field15)
  • teach_id (Key2) — Foreign key → Teachers.teach_id — NOT NULL

Student (Untitled6)

  • 코드 (Key) — INT — Primary key — NOT NULL
  • 이름 (Field) — var
  • 전화번호 (Field2) — var

Teachers (Untitled4)

  • teach_id (Key) — Primary key — NOT NULL
  • name (Field)
  • Field2
  • class (Field3)

Untitled11

    worker (Untitled8)

    • 사번 (Key) — int — Primary key — NOT NULL
    • 이름 (Field) — var
    • 전화번호 (Field3) — var
    • 파트 (Key2) — var — Foreign key → Part.파트 — NOT NULL