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