Lawyer-ai
Tables (4)
chats (user chat data)
- id (chat_id) — interger — Primary key — NOT NULL
- user_id (id2) — interger — Foreign key → users.user_id — NOT NULL
- title (Chat title) — varchar
- reg_date (created date) — DATE_TIME
documents_users (documents for members)
- user_id (id for documents) — interger — Foreign key → users.user_id — NOT NULL
- document_name (document name) — varchar
- owner_name (owner name) — varchar
- reciever_name (reciever name) — varchar
- context — text
- reg_date (created date) — DATE_TIME
- upt_date (updated date) — DATE_TIME
roles (user roles)
- user_id (id) — interger — Foreign key → users.user_id — NOT NULL
- role_name (role) — varchar
- description (explaination) — text
users (members)
- user_id (id) — interger — Primary key — NOT NULL
- username (nickname) — varchar
- password — varchar
- name — varchar
- birth_date (birth date) — DATE
- email — varchar
- phone (Phone number) — int
- reg_date (created date) — DATE_TIME
- upt_date (updated date) — DATE_TIME