Kezul
Tables (11)
Untitled (users)
- Key (id) — UUID — Primary key — NOT NULL
- Field (username) — varchar — NOT NULL
- Field2 (password) — varchar — NOT NULL
- Field (email) — varchar — NOT NULL
- Field (phone_number) — varchar — NOT NULL
- Field2 (role) — varchar — NOT NULL
Untitled (attachments)
- Key (id) — uuid — Primary key — NOT NULL
- Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
- Field (origin_filename) — varchar — NOT NULL
- Field (saved_filename) — varchar — NOT NULL
- Field (volume) — varchar — NOT NULL
- Field (extension) — varchar — NOT NULL
Untitled (informations)
- Key (id) — uuid — Primary key — NOT NULL
- Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
- Field (contents) — varchar — NOT NULL
Untitled (certifications)
- Key (id) — uuid — Primary key — NOT NULL
- Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar — NOT NULL
Untitled (programs)
- Key (id) — uuid — Primary key — NOT NULL
- Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar — NOT NULL
- Field (contents) — varchar — NOT NULL
Untitled (posts)
- Key (id) — UUID — Primary key — NOT NULL
- Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
- Field (age) — SMALLINT
- Field (type) — varchar
- Field (days) — varchar
- Field (time) — varchar
- Field (period) — varchar
- Field (contents) — varchar
- Field (athletic_career) — varchar
Untitled (types)
- Key (id) — UUID — Primary key — NOT NULL
- Field (name) — VARCHAR — NOT NULL
Untitled (post_types)
- Key (id) — UUID — Primary key — NOT NULL
- Key (post_id) — UUID — Foreign key → Untitled.Key — NOT NULL
- Key (type_id) — UUID — Foreign key → Untitled.Key — NOT NULL
Untitled (chat_rooms)
- Key (id) — UUID — Primary key — NOT NULL
Untitled (participants)
- Key (id) — UUID — Primary key — NOT NULL
- Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
- Key (chatroom_id) — UUID — Foreign key → Untitled.Key — NOT NULL
Untitled (chat_messages)
- Key (id) — UUID — Primary key — NOT NULL
- Key (chatroom_id) — UUID — Foreign key → Untitled.Key — NOT NULL
- Key (sender) — UUID — Foreign key → Untitled.Key — NOT NULL
- Field (read) — boolean — NOT NULL
- Field2 (content) — varchar — NOT NULL