DalbbitChats

Tables (14)

Chats (CopyOfPeepChats)

  • chatid (Key) — String — Primary key — NOT NULL
  • uid (Key2) — String — Foreign key → User.uid — NOT NULL
  • createTime (TimeStamp) — TimeStmap
  • Messages (Map) — Map
  • targetMessages (Field2) — Map
  • targetUid (Field4) — String
  • updateTime (Field) — TimeStamp

FStockMaster (Untitled4)

  • code (Key) — String — Primary key — NOT NULL
  • code2 (Key2) — String — Primary key — NOT NULL
  • name (Field) — String
  • nameEng (Field9) — String
  • typ (Field2) — String
  • volume (Field3) — Integer
  • volumePrice (Field4) — Integer
  • tradePrice (Field5) — Integer
  • chngPrice (Field6) — Integer
  • chngRate (Field7) — Integer
  • chng (Field8) — String

FStockNews (Untitled5)

  • code2 (Key2) — String — Foreign key → FStockMaster.code2 — NOT NULL
  • link (Field) — String
  • datetime (Field2) — datetime
  • agency (Field3) — String
  • title (Field4) — String
  • content (Field5) — String
  • score_gpt (Field6) — Integer
  • score_you (Field7) — Integer
  • evaulation_gpt (Field8) — Integer
  • evaluation_you (Field9) — Integer
  • summary_gpt (Field10) — String

GroupDetail (Untitled6)

  • groupID (Key) — String — Primary key — NOT NULL
  • adminId (Field2) — String
  • groupName (Field)
  • adminName (Field3) — String
  • createdAt (Field4) — TimeStamp
  • groupIcon (Field5) — String
  • members (Field6) — String
  • recenetMessage (Field7) — Array
  • uid (Key2) — Foreign key → User.uid — NOT NULL

GroupMessages (CopyOfUntitled6)

  • groupID (Key2) — String — Foreign key → GroupDetail.groupID — NOT NULL
  • from_id (Field6) — String
  • message (Field7) — String
  • status (Field8) — Int
  • createAt (Field9) — TimeStamp
  • to_id (Field10) — String
  • chat_message_type (Field) — String
  • chat_type (Field2) — String
  • content_type (Field3) — String

Messages (CopyOfUntitled)

  • uid (Key2) — String — Foreign key → User.uid — NOT NULL
  • content (Field) — String
  • createTime (Field2) — TimeStamp
  • targetUid (Field5) — String
  • type (Field6) — String

PeepChats

  • chatid (Key) — String — Primary key — NOT NULL
  • uid (Key2) — String — Foreign key → User.uid — NOT NULL
  • createTime (TimeStamp) — TimeStmap
  • Messages (Map) — Map
  • targetMessages (Field2) — Map
  • targetUid (Field4) — String
  • updateTime (Field) — TimeStamp
  • roomIconUrl (Field3) — String
  • roomName (Field5) — String

PeepMessages (Untitled)

  • uid (Key2) — String — Foreign key → User.uid — NOT NULL
  • content (Field) — String
  • createTime (Field2) — TimeStamp
  • roomName (Field3) — String
  • targetName (Field4) — String
  • targetUid (Field5) — String
  • type (Field6) — String

PeepUsers (Untitled3)

  • uid (Key) — String — Foreign key → User.uid — NOT NULL
  • createTime (Field) — TimeStamp
  • iconUrl (Field2) — String
  • roomName (Field3) — String
  • targetName (Field4) — String
  • uid (Field5) — Uid

SQLite PeepChats (SqlLite)

  • id (Key) — String — Primary key — NOT NULL
  • roomName (Key2) — String — Primary key — NOT NULL
  • roomIcon (Field3) — String
  • createTime (TimeStamp) — TimeStmap
  • updateTime (Field) — TimeStamp

SQLite PeepMessages (PeepMessages)

  • roomName (Key2) — String — Foreign key → SQLite PeepChats.roomName — NOT NULL
  • content (Field) — String
  • createTime (Field2) — TimeStamp
  • targetUid (Field5) — String
  • targetName (Field4) — String
  • uid (Field3) — String
  • type (Field6) — String

SQLite PeepTargetMessages (CopyOfPeepMessages)

  • roomName (Key2) — String — Foreign key → SQLite PeepChats.roomName — NOT NULL
  • content (Field) — String
  • createTime (Field2) — TimeStamp
  • targetName (Field4) — String
  • targetUid (Field5) — String
  • uid (Field3) — String
  • type (Field6) — String

SQLite PeepUsers (CopyOfUntitled3)

  • roomName (Key) — String — Foreign key → SQLite PeepChats.id — NOT NULL
  • createTime (Field) — TimeStamp
  • icon (Field2) — String
  • targetName (Field4) — String

User (Untitled2)

  • uid (Key) — Primary key — NOT NULL
  • chats (Field5) — List
  • contacts (Field6) — List
  • kakaoChats (Field) — List
  • lastLoginTime (Field2) — TimeStamp
  • online (Field3) — bool
  • photoURL (Field4) — String
  • Suggest (Field7) — String
  • uid (Field8) — String
  • userName (Field9) — String
  • chatGPTCredit (Field10) — Integer
  • chatGPTExpired (Field11) — Datetime
  • Groups (Field12) — String