ptt

Tables (8)

callHist (Untitled8)

  • idx (Key) — long — Primary key — NOT NULL
  • Field

chat (Untitled4)

  • idx (Key) — long — Primary key — NOT NULL
  • chatRoomIdx (Key2) — long — Foreign key → chatRoom.idx — NOT NULL
  • textcontent (Field) — string
  • type (Field2) — int — NOT NULL
  • filepath (Field3) — string
  • ins_date (Field4) — date — NOT NULL
  • from_uri (Field5) — string — NOT NULL
  • user_number (Field6) — string — NOT NULL
  • user_name (Field7) — string
  • owner (Field8) — string — NOT NULL

chatRoom (Untitled3)

  • idx (Key) — long — Primary key — NOT NULL
  • room_prim_num(request_uri) (Field) — string — NOT NULL
  • last_ins_date (Field2) — date
  • room_name (Field3) — string
  • last_ins_chat_idx (Field4) — long
  • group_idx (Key2) — long — Foreign key → group.idx

group (Untitled5)

  • idx (Key) — long — Primary key — NOT NULL
  • group_num (Field) — string
  • group_name (Field2) — string
  • users_hash (Field3) — string — NOT NULL
  • is_udg (Field4) — boolean

group_user (Untitled7)

  • idx (Key) — long — Foreign key → user.idx — NOT NULL
  • idx (Key2) — long — Foreign key → group.idx — NOT NULL

recordedMedia (Untitled)

  • idx (Key) — long — Primary key — NOT NULL
  • type (Field) — int — NOT NULL
  • ins_date (Field2) — date — NOT NULL
  • file_path (Field3) — string — NOT NULL
  • direction (Field4) — int — NOT NULL
  • user_idx (Key2) — long — Foreign key → user.idx
  • group_idx (Key3) — long — Foreign key → group.idx

setting (Untitled6)

  • idx (Key) — long — Primary key — NOT NULL
  • indent (Field) — int
  • type (Field2) — int
  • title (Field3) — string
  • contenttext (Field4) — string
  • parentidx (Field5) — long

user (Untitled2)

  • idx (Key) — long — Primary key — NOT NULL
  • name (field) — string
  • number (Field) — string