AI Fence

Tables (6)

embedding vectors of each document (EMBEDDINGS)

  • unique ID (id) — numeric id value — Foreign key → legal case documents info.unique ID — NOT NULL
  • embedding — embedding vector

legal case documents info (DOCUMENTS)

  • unique ID (id) — numeric id value — Primary key — NOT NULL
  • summary — summary of legal case
  • type — civil or criminal
  • date — date and time of the verdict
  • url — legal case url
  • reference — legal case reference number
  • court — court
  • answer — answer
  • title — document title
  • subtitle — subtitle
  • abstract — abstract of the document
  • background — background
  • specialty — specialty
  • createdAt — timestamp of the insert

records of the user's search queries (SEARCHES)

  • unique ID (id) — numeric id value — Primary key — NOT NULL
  • unique key (id2) — unique identifier — Foreign key → user table.unique key — NOT NULL
  • query sentence (query) — user's querying sentence
  • ip address (ipAddress) — user's ip address during search

records of when user loggedin (LOGGEDIN)

  • unique ID (id) — numeric id — Primary key — NOT NULL
  • unique key (id2) — unique identifier — Foreign key → user table.unique key — NOT NULL
  • logged in at (createdAt) — timestamp when the user was logged in
  • ip address (ipAddress) — user's IP address during login

search result that the user clicked (SEARCHCLICK)

  • unique ID (id) — numeric id value — Primary key — NOT NULL
  • unique ID (id2) — SEARCHES' unique ID — Foreign key → records of the user's search queries.unique ID — NOT NULL
  • unique key (id22) — uuid of the user who searched and clicked — Foreign key → records of the user's search queries.unique key — NOT NULL
  • unique ID (id3) — document id — Foreign key → legal case documents info.unique ID — NOT NULL
  • rank number (rank) — rank number that the user clicked
  • time when clicked (createdAt) — datetime when the user clicked

user table (USERS)

  • unique key (id) — unique identifier — Primary key — NOT NULL
  • user's login email (email) — user's login email
  • login password (password) — user's login password
  • SNS method (sns) — user's SNS login method
  • user name (username) — user's display name
  • email verified (emailverified) — user's email is verified or not
  • email verification code (emailcode) — email verification code
  • user type (usertype) — admin or regular user
  • is active (isActive) — is active user or not
  • created at first (createdAt) — datetime when the user was created