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)
worker (Untitled8)
- 사번 (Key) — int — Primary key — NOT NULL
- 이름 (Field) — var
- 전화번호 (Field3) — var
- 파트 (Key2) — var — Foreign key → Part.파트 — NOT NULL