work wave

Tables (8)

Calender (Untitled2)

  • calender_id (PK) — Primary key — NOT NULL
  • owner_type (Field)
  • owner_id (FK)
  • date (Field3)
  • event_type (Field4)
  • event_id (Foreign Key)
  • color_index_id (Field6)

ColorIndex (Untitled7)

  • color_index_id (PK) — Primary key — NOT NULL
  • color_name (Field)
  • color_code (Field2)

Notice (Untitled6)

  • notice_id (PK) — Primary key — NOT NULL
  • owner_type (Field)
  • owner_id (Fk)
  • title (Field2)
  • content (Field3)
  • notice_date (Field4)
  • color_index_id (Field5)

Owner (Untitled8)

  • owner_id (Key) — Primary key — NOT NULL
  • owner_type (Field)
  • entity_id (Field2)

Team (Untitled3)

  • team_id (PK) — Primary key — NOT NULL
  • team_name (Field)

TodoList (Untitled)

  • todo_id (PK) — Primary key — NOT NULL
  • owner_type (Field)
  • owner_id (fk)
  • user_id (FK)
  • title (Field2)
  • description (Field3)
  • (Field4)
  • (Field5)
  • color_index_id (Field6)

User (Untitled5)

  • user_id (PK) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • email (Field3)

UserTeam (Untitled4)

  • user_team_id (PK) — Primary key — NOT NULL
  • user_id (FK)
  • team_id (fk)