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