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