Database Tables
Table: cache
Table "public.cache"
Column | Type | Collation | Nullable | Default
------------+------------------------+-----------+----------+---------
key | character varying(255) | | not null |
value | text | | not null |
expiration | bigint | | not null |
Indexes:
"cache_pkey" PRIMARY KEY, btree (key)
"cache_expiration_index" btree (expiration)Table: cache_locks
Table "public.cache_locks"
Column | Type | Collation | Nullable | Default
------------+------------------------+-----------+----------+---------
key | character varying(255) | | not null |
owner | character varying(255) | | not null |
expiration | bigint | | not null |
Indexes:
"cache_locks_pkey" PRIMARY KEY, btree (key)
"cache_locks_expiration_index" btree (expiration)Table: failed_jobs
Table "public.failed_jobs"
Column | Type | Collation | Nullable | Default
------------+--------------------------------+-----------+----------+-----------------------------------------
id | bigint | | not null | nextval('failed_jobs_id_seq'::regclass)
uuid | character varying(255) | | not null |
connection | character varying(255) | | not null |
queue | character varying(255) | | not null |
payload | text | | not null |
exception | text | | not null |
failed_at | timestamp(0) without time zone | | not null | CURRENT_TIMESTAMP
Indexes:
"failed_jobs_pkey" PRIMARY KEY, btree (id)
"failed_jobs_connection_queue_failed_at_index" btree (connection, queue, failed_at)
"failed_jobs_uuid_unique" UNIQUE CONSTRAINT, btree (uuid)Table: job_batches
Table "public.job_batches"
Column | Type | Collation | Nullable | Default
----------------+------------------------+-----------+----------+---------
id | character varying(255) | | not null |
name | character varying(255) | | not null |
total_jobs | integer | | not null |
pending_jobs | integer | | not null |
failed_jobs | integer | | not null |
failed_job_ids | text | | not null |
options | text | | |
cancelled_at | integer | | |
created_at | integer | | not null |
finished_at | integer | | |
Indexes:
"job_batches_pkey" PRIMARY KEY, btree (id)Table: jobs
Table "public.jobs"
Column | Type | Collation | Nullable | Default
--------------+------------------------+-----------+----------+----------------------------------
id | bigint | | not null | nextval('jobs_id_seq'::regclass)
queue | character varying(255) | | not null |
payload | text | | not null |
attempts | smallint | | not null |
reserved_at | integer | | |
available_at | integer | | not null |
created_at | integer | | not null |
Indexes:
"jobs_pkey" PRIMARY KEY, btree (id)
"jobs_queue_index" btree (queue)Table: migrations
Table "public.migrations"
Column | Type | Collation | Nullable | Default
-----------+------------------------+-----------+----------+----------------------------------------
id | integer | | not null | nextval('migrations_id_seq'::regclass)
migration | character varying(255) | | not null |
batch | integer | | not null |
Indexes:
"migrations_pkey" PRIMARY KEY, btree (id)Table: password_reset_tokens
Table "public.password_reset_tokens"
Column | Type | Collation | Nullable | Default
------------+--------------------------------+-----------+----------+---------
email | character varying(255) | | not null |
token | character varying(255) | | not null |
created_at | timestamp(0) without time zone | | |
Indexes:
"password_reset_tokens_pkey" PRIMARY KEY, btree (email)Table: sessions
Table "public.sessions"
Column | Type | Collation | Nullable | Default
---------------+------------------------+-----------+----------+---------
id | character varying(255) | | not null |
user_id | bigint | | |
ip_address | character varying(45) | | |
user_agent | text | | |
payload | text | | not null |
last_activity | integer | | not null |
Indexes:
"sessions_pkey" PRIMARY KEY, btree (id)
"sessions_last_activity_index" btree (last_activity)
"sessions_user_id_index" btree (user_id)Table: users
Table "public.users"
Column | Type | Collation | Nullable | Default
-------------------+--------------------------------+-----------+----------+-----------------------------------
id | bigint | | not null | nextval('users_id_seq'::regclass)
name | character varying(255) | | not null |
email | character varying(255) | | not null |
email_verified_at | timestamp(0) without time zone | | |
password | character varying(255) | | not null |
remember_token | character varying(100) | | |
created_at | timestamp(0) without time zone | | |
updated_at | timestamp(0) without time zone | | |
Indexes:
"users_pkey" PRIMARY KEY, btree (id)
"users_email_unique" UNIQUE CONSTRAINT, btree (email)