Cowork ERD

Tables (9)

ACCOUNT (1)

  • _id (1) — varchar(6) — Primary key — NOT NULL
  • email (2) — text
  • password (3) — text
  • created_at (4) — integer

MESSAGE_LOG (9)

  • msgno (1) — integer — Primary key — NOT NULL
  • _id (2) — varchar(6)
  • rmno (3) — integer
  • msgtype (4) — varchar(7)
  • message (5) — text
  • created_at (6) — integer

PROFILE (2)

  • _id (1) — varchar(6) — Foreign key → ACCOUNT._id — NOT NULL
  • usrname (2) — varchar(20)
  • usrimage (3) — text
  • usrstatusimage (4) — integer
  • usrstatusmessage (5) — text
  • usrphone (6) — varchar(30)
  • usrtoken (7) — text

PROJECT (3)

  • prjno (1) — integer — Primary key — NOT NULL
  • _id (2) — varchar(6) — Foreign key → PROFILE._id — NOT NULL
  • prjname (3) — text
  • created_at (4) — integer

PROJECT_INVITE (5)

  • prjno (1) — integer — Foreign key → PROJECT.prjno — NOT NULL
  • send_id (2) — varchar(6) — Foreign key → PROJECT._id — NOT NULL
  • target_id (3) — varchar(6)
  • created_at (4) — integer

PROJECT_MEMBER (6)

  • prjno (1) — integer — Foreign key → PROJECT.prjno — NOT NULL
  • _id (2) — varchar(6)
  • joined_at (3) — integer

PROJECT_ROOM (7)

  • prjno (1) — integer — Foreign key → PROJECT.prjno — NOT NULL
  • rmno (2) — integer — Foreign key → ROOM.rmno — NOT NULL

ROOM (4)

  • rmno (1) — integer — Primary key — NOT NULL
  • _id (2) — varchar(6) — Foreign key → PROJECT._id — NOT NULL
  • rmtype (3) — varchar(7)
  • rmname (4) — varchar(20)
  • rmpurpose (5) — text
  • chtype (6) — varchar(7)
  • created_at (7) — integer

ROOM_MEMBER (8)

  • rmno (1) — integer — Foreign key → ROOM.rmno — NOT NULL
  • _id (2) — varchar(6) — Foreign key → ROOM._id — NOT NULL
  • isstarred (3) — boolean
  • joined_at (4) — integer