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