- users
- services
- files
NOT NULL
- id Primary Key 28 length character
- mainpass byte array
- bool boolean
CREATE TABLE IF NOT EXISTS users (
id CHAR(28) NOT NULL PRIMARY KEY,
main_pass BYTEA NOT NULL,
bool BOOLEAN NOT NULL
);
- user_id 28 length character REFERENCES users (id)
- password byte array NOT NULL
- name variable character NOT NULL
- username variable character NOT NULL
CREATE TABLE IF NOT EXISTS services (
name VARCHAR(255) NOT NULL PRIMARY KEY,
username VARCHAR(255) NOT NULL,
password BYTEA NOT NULL,
user_id CHAR(28) NOT NULL REFERENCES users (id));