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