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