WS
Tables (6)
CLASSES (enrole_info)
- class_name (FK) — VARCHAR — Primary key
- ID (Key) — Foreign key → USER_CLASSES.ID — NOT NULL
- professor_id (Field2) — VARCHAR
- student_id (Field3) — VARCHAR
DOCUMENT (document)
- ID (PK) — INT — Primary key — NOT NULL
- class_name (FK) — VARCHAR — Foreign key → CLASSES.class_name
- ID (Key) — Foreign key → CLASSES.ID — NOT NULL
- name (Feld1) — VARCHAR
- authrization (Field3) — INT
- body (Field) — STRING
- doc_type (Field2) — VARCHAR
- due_date (Field4) — DATETIME(6)
DOCUMENT_PILE (CopyOfdocument)
- ID (PK) — INT — Primary key — NOT NULL
- name (Feld1) — VARCHAR
- authrization (Field3) — INT
- body (Field) — STRING
- doc_type (Field2) — VARCHAR
USER (user_info)
- ID (Key) — VARCHAR — Foreign key → USER_CLASSES.ID — NOT NULL
- name (Feld1) — VARCHAR
- email (Field2) — VARCHAR
- authrization (Field3) — INT
- role (Field) — VARCHAR
- PW (Field4) — VARCHAR — NOT NULL
USER (CopyOfuser_info)
- ID (Key) — VARCHAR — Primary key — NOT NULL
- name (Feld1) — VARCHAR
- email (Field2) — VARCHAR
- authrization (Field3) — INT
- PW (Field4) — VARCHAR — NOT NULL
USER_CLASSES (Untitled)
- ID (Key) — Primary key — NOT NULL
- class_name (FK) — VARCHAR
- Field2 (FK2) — VARCHAR