lms

Tables (5)

aoji (Untitled5)

  • aoji_id_PK (Key) — Primary key — NOT NULL
  • userinfo_id_FK (Key2) — Foreign key → latest_info.userinfo_id_PK — NOT NULL
  • Field

attend (Untitled3)

  • attend_id_PK (Key) — Primary key — NOT NULL
  • userinfo_id_FK (Key2) — Foreign key → latest_info.userinfo_id_PK — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

latest_info (Untitled4)

  • userinfo_id_PK (Key) — Primary key — NOT NULL
  • usre_id_FK (Key2) — Foreign key → user.Key — NOT NULL
  • nick_name (Field)
  • team (Field2)
  • role (Field3)
  • attend_status (Field4)
  • vacation (Field5)
  • level (Field6)
  • participate_score (Field7)
  • attende_score (Field8)

todo (Untitled2)

  • todo_id_PK (Key) — Primary key — NOT NULL
  • userinfo_id_FK (Key2) — Foreign key → latest_info.userinfo_id_PK — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

user (Untitled)

  • Key — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • email (Field3)
  • (Field4)
  • Field5
  • Field6
  • Field7