Access数据库的中长字符串字段

CREATE TABLE oauth2_registered_client (
    id varchar(36) NOT NULL,
    client_id varchar(64) NOT NULL,
    client_id_issued_at timestamp NOT NULL,
    client_secret varchar(255) NULL ,
    client_secret_expires_at timestamp NULL,
    client_name varchar(64) NOT NULL,
    client_authentication_methods varchar(255) NOT NULL,
    authorization_grant_types varchar(255) NOT NULL,
    redirect_uris memo NULL ,
    post_logout_redirect_uris memo NULL ,
    scopes varchar(255) NOT NULL,
    client_settings memo  NOT NULL,
    token_settings text NOT NULL

);

CREATE TABLE oauth2_authorization (
    id varchar(36) NOT NULL,
    registered_client_id varchar(64) NOT NULL,
    principal_name varchar(64) NOT NULL,
    authorization_grant_type varchar(100) NOT NULL,
    authorized_scopes varchar(255) NULL,
    [attributes] memo NULL,
    state varchar(255) NULL,
    authorization_code_value memo NULL,
    authorization_code_issued_at timestamp NULL,
    authorization_code_expires_at timestamp NULL,
    authorization_code_metadata memo NULL,
    access_token_value memo NULL,
    access_token_issued_at timestamp NULL,
    access_token_expires_at timestamp NULL,
    access_token_metadata memo NULL,
    access_token_type varchar(100) NULL,
    access_token_scopes varchar(255) NULL,
    oidc_id_token_value memo NULL,
    oidc_id_token_issued_at timestamp NULL,
    oidc_id_token_expires_at timestamp NULL,
    oidc_id_token_metadata memo NULL,
    refresh_token_value memo NULL,
    refresh_token_issued_at timestamp NULL,
    refresh_token_expires_at timestamp NULL,
    refresh_token_metadata memo NULL,
    user_code_value memo NULL,
    user_code_issued_at timestamp NULL,
    user_code_expires_at timestamp NULL,
    user_code_metadata memo NULL,
    device_code_value memo NULL,
    device_code_issued_at timestamp NULL,
    device_code_expires_at timestamp NULL,
    device_code_metadata memo NULL
)

CREATE TABLE oauth2_authorized_client (
    client_registration_id varchar(64) NOT NULL,
    principal_name varchar(64) NOT NULL,
    access_token_type varchar(100) NOT NULL,
    access_token_value binary NOT NULL,
    access_token_issued_at timestamp NOT NULL,
    access_token_expires_at timestamp NOT NULL,
    access_token_scopes varchar(255) NULL,
    refresh_token_value binary NULL,
    refresh_token_issued_at timestamp NULL,
    created_at timestamp NOT NULL DEFAULT
);

---

Access数据类型大全

文本：char(n)、string(n)、text(n) 、varchar(n) 其中n表示字段大小

备注：memo

数字：

　　　　字节：byte

　　　　长整型：long、int、integer

　　　　整型：short、smallint

　　　　单精度型：single、real

　　　　双精度型：double、float

日期/时间：date、datetime、time、timestamp

货币：currency、money

自动编号：counter(m,n)、autoincrement(m,n) m为初始值，n为步长值，如果不写默认值是(1,1)

是/否：bit、yesno

OLE对象：image

二进制：binary