rohrkatze-rotator database schema - node version

katze-schema.txt

postgres=# \c katze
You are now connected to database "katze" as user "postgres".
katze=# \dt
           List of relations
 Schema |    Name    | Type  |  Owner   
--------+------------+-------+----------
 public | guilds     | table | postgres
 public | roleme     | table | postgres
 public | roles      | table | postgres
 public | starboard  | table | postgres
 public | usage      | table | postgres
 public | who        | table | postgres
(8 rows)

katze=# \d guilds
                   Table "public.guilds"
   Column    |  Type   | Collation | Nullable |  Default   
-------------+---------+-----------+----------+------------
 id          | bigint  |           | not null | 
 name        | text    |           |          | 
 channelcd   | integer |           |          | 0
 membercd    | integer |           |          | 0
 locale      | text    |           |          | 'en'::text
 activity    | bigint  |           |          | 
 timeout     | integer |           |          | 
 meme        | boolean |           |          | 
 dont        | boolean |           |          | 
 emoji       | text    |           |          | '⭐'::text
 slowrole    | bigint  |           |          | 
 starboard   | bigint  |           |          | 
 pinboardin  | bigint  |           |          | 
 pinboardout | bigint  |           |          | 
 cleanpins   | boolean |           |          | 
 rolestate   | boolean |           |          | 
 lasttime    | bigint  |           |          | 
 current     | bigint  |           |          | 
 twig        | boolean |           |          | 
 starmin     | integer |           |          | 
 vtrack      | boolean |           |          | 
 void        | bigint  |           |          | 
Indexes:
    "guilds_pkey1" PRIMARY KEY, btree (id)

katze=# \d roleme
              Table "public.roleme"
 Column |  Type  | Collation | Nullable | Default 
--------+--------+-----------+----------+---------
 id     | bigint |           | not null | 
 guild  | bigint |           |          | 
 color  | text   |           |          | 
Indexes:
    "roleme_pkey" PRIMARY KEY, btree (id)

katze=# \d roles
                 Table "public.roles"
   Column   |  Type  | Collation | Nullable | Default 
------------+--------+-----------+----------+---------
 role       | bigint |           | not null | 
 invitecode | text   |           | not null | 
 guild      | bigint |           | not null | 
Indexes:
    "roles_pkey" PRIMARY KEY, btree (role)

katze=# \d starboard
              Table "public.starboard"
 Column  |  Type   | Collation | Nullable | Default 
---------+---------+-----------+----------+---------
 date    | bigint  |           |          | 
 guild   | bigint  |           |          | 
 member  | bigint  |           |          | 
 channel | bigint  |           |          | 
 message | bigint  |           | not null | 
 post    | bigint  |           |          | 
 stars   | integer |           |          | 
Indexes:
    "starboard_pkey1" PRIMARY KEY, btree (message)

katze=# \d usage
                 Table "public.usage"
   Column    |  Type  | Collation | Nullable | Default 
-------------+--------+-----------+----------+---------
 guild       | bigint |           | not null | 
 botstats    | bigint |           |          | 0
 eval        | bigint |           |          | 0
 help        | bigint |           |          | 0
 invite      | bigint |           |          | 0
 ping        | bigint |           |          | 0
 pong        | bigint |           |          | 0
 shardinfo   | bigint |           |          | 0
 usage       | bigint |           |          | 0
 activity    | bigint |           |          | 0
 meme        | bigint |           |          | 0
 dont        | bigint |           |          | 0
 slowrole    | bigint |           |          | 0
 cleanpins   | bigint |           |          | 0
 rolestate   | bigint |           |          | 0
 avatar      | bigint |           |          | 0
 delete      | bigint |           |          | 0
 emojis      | bigint |           |          | 0
 farm        | bigint |           |          | 0
 link        | bigint |           |          | 0
 list        | bigint |           |          | 0
 migratepins | bigint |           |          | 0
 owo         | bigint |           |          | 0
 pin         | bigint |           |          | 0
 pinboard    | bigint |           |          | 0
 pls         | bigint |           |          | 0
 roleme      | bigint |           |          | 0
 roles       | bigint |           |          | 0
 rotate      | bigint |           |          | 0
 show        | bigint |           |          | 0
 star        | bigint |           |          | 0
 starboard   | bigint |           |          | 0
 timeout     | bigint |           |          | 0
 events      | bigint |           |          | 0
 count       | bigint |           |          | 0
 pick        | bigint |           |          | 0
 what        | bigint |           |          | 0
 twig        | bigint |           |          | 0
 starmin     | bigint |           |          | 0
 convert     | bigint |           |          | 0
 colorme     | bigint |           |          | 0
 vtrack      | bigint |           |          | 0
 choose      | bigint |           |          | 0
 void        | bigint |           |          | 0
 shuffle     | bigint |           |          | 0
 steal       | bigint |           |          | 0
 changeavy   | bigint |           |          | 0
 arteezy     | bigint |           |          | 0
 mike        | bigint |           |          | 0
Indexes:
    "usage_pkey" PRIMARY KEY, btree (guild)

katze=# \d who
                Table "public.who"
 Column  |  Type  | Collation | Nullable | Default 
---------+--------+-----------+----------+---------
 message | bigint |           |          | 
 member  | bigint |           |          | 
Indexes:
    "who_message_member_key" UNIQUE CONSTRAINT, btree (message, member)