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