admin_sessions

Description

Table Definition

CREATE TABLE `admin_sessions` (
  `sid` varchar(64) NOT NULL,
  `user_id` char(36) NOT NULL,
  `access_token` text NOT NULL,
  `id_token` text NOT NULL,
  `refresh_token` text NOT NULL,
  `expires_at` datetime(6) NOT NULL,
  `created_at` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updated_at` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`sid`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
sid	varchar(64)		false
user_id	char(36)		false
access_token	text		false
id_token	text		false
refresh_token	text		false
expires_at	datetime(6)		false
created_at	datetime(6)	CURRENT_TIMESTAMP(6)	false
updated_at	datetime(6)	CURRENT_TIMESTAMP(6)	false	DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (sid)

Indexes

Name	Definition
PRIMARY	PRIMARY KEY (sid) USING BTREE

Relations

        erDiagram


"admin_sessions" {
  varchar_64_ sid PK
}
    

---

Generated by tbls