news_subscription
Subscriptions on news of Doctor Web company.
Table fields
Field name
|
Field type
|
Description
|
sid
|
VARCHAR(36) NOT NULL
|
server ID
|
aid
|
VARCHAR(36) NOT NULL
|
admin UUID
|
did
|
VARCHAR(36) NOT NULL
|
news sections ID
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
subscription time
|
Table indexes
Index name
|
Index type
|
Fields list
|
news_subscription_0001
|
simple table index
|
did, sid
|
news_subscription_pkey
|
table primary key
clustering index
|
sid, aid, did
|
Table references
Field name
|
Direction
|
Referenced table field
|
aid
|
→
|
admins.id
|
did
|
→
|
news_known_did.did
|
server_schedule
Server scheduler tasks.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
Server ID
|
item
|
VARCHAR(36) NOT NULL
|
task UUID
|
format
|
INTEGER DEFAULT '0'
|
value format
|
prefix
|
VARCHAR(64) NOT NULL
|
option prefix: is it time or action
|
field
|
VARCHAR(64) NOT NULL
|
option name
|
seq
|
INTEGER NOT NULL
|
option sequence number
|
asnumber
|
NUMERIC(19) DEFAULT '0'
|
option value as a number
|
asstring
|
CLOB DEFAULT ''
|
option value as a string
|
Table indexes
Index name
|
Index type
|
Fields list
|
server_schedule_pkey
|
table primary key
clustering index
|
id, item, prefix, field, seq
|
|