projectDB
Tables (8)
ContactsTeams (contactsteams)
- UserId (userid) — VARCHAR(255) — Foreign key → Users.UserId — NOT NULL
- TeamName (teamname) — VARCHAR(255) — Foreign key → Teams.TeamName — NOT NULL
HaperParmeter (haperparmeter)
LightWeight (lightweight)
Models (models)
- ModelID (modelid) — BIGINT(11) — Primary key — NOT NULL
- ModelName (modelname) — VARCHAR(255)
- State (state) — VARCHAR(255)
- CreatedBy (createdby) — VARCHAR(255)
- TimeSpan — BIGINT(255)
- ProjectID (projectid) — VARCHAR(255) — Foreign key → Projects.ProjectID — NOT NULL
- CreatedTime (createdtime) — DATE(3)
Projects (projects)
- ProjectID (projectId) — BIGINT(11) — Primary key — NOT NULL
- Description (description) — VARCHAR(255)
- UserId (userid) — VARCHAR(255) — Foreign key → Users.UserId — NOT NULL
- TeamName (teamname) — VARCHAR(255) — Foreign key → Teams.TeamName — NOT NULL
- ProjectName (projectname) — VARCHAR(255)
Teams (teams)
- TeamName (teamname) — VARCHAR(255) — Primary key — NOT NULL
- Description (descripiton) — VARCHAR(255)
- Privacy (privacy) — BINARY(1)
Users (users)
- UserId (userid) — VARCHAR(255) — Primary key — NOT NULL
- Password (password) — VARCHAR(255)
- UserName (username) — VARCHAR(255)
- Photo (photo) — VARCHAR(255)
- Region (region) — VARCHAR(255)
- Email (email) — VARCHAR(255)
- Description (description) — VARCHAR(255)