UMC
Tables (4)
Chat (CopyOfUntitled)
- chatIdx (Key) — int identity — Primary key — NOT NULL
- roomIdx (Field) — int
- message (Field2) — text
- status (Field5) — varchar(10) default-'ACTIVE'
- createAt (Field6) — timestamp default-CURRENT_TIMESTAMP
- updateAt (Field7) — timestamp default-CURRENT_TIMESTAMP
Member (CopyOfCopyOfUntitled)
- memberIdx (Key) — int identity — Primary key — NOT NULL
- roomIdx (Field) — int
- userIdx (Field2) — int
- status (Field5) — varchar(10) default-'ACTIVE'
- createAt (Field6) — timestamp default-CURRENT_TIMESTAMP
- updateAt (Field7) — timestamp default-CURRENT_TIMESTAMP
Room (CopyOfCopyOfUntitled2)
- roomIdx (Key) — int identity — Primary key — NOT NULL
- name (Field) — varchar(20)
- imgUrl (Field2) — text null
- status (Field5) — varchar(10) default-'ACTIVE'
- createAt (Field6) — timestamp default-CURRENT_TIMESTAMP
- updateAt (Field7) — timestamp default-CURRENT_TIMESTAMP
User (Untitled)
- userIdx (Key) — int identity — Primary key — NOT NULL
- name (Field) — varchar(30)
- email (Field2) — varchar(50)
- profileImgUrl (Field3) — text null
- backGroundImgUrl (Field4) — text null
- status (Field5) — varchar(10) default-'ACTIVE'
- createAt (Field6) — timestamp default-CURRENT_TIMESTAMP
- updateAt (Field7) — timestamp default-CURRENT_TIMESTAMP