- docs/contract.md: 唯一规格来源(信封/cipher/端点/权限/种子/验收门) - docs/ddl/base_ddl_raw.sql: 从官方 JNPF dump 逐字提取的 7 张 base_* DDL - CLAUDE.md / HANDOFF.md: 项目级 agent 指引与交接文档 Co-Authored-By: Claude <[email protected]>
207 lines
6.4 KiB
SQL
207 lines
6.4 KiB
SQL
-- ===== base_authorize ===== (source lines 812-829)
|
|
CREATE TABLE base_authorize (
|
|
f_id VARCHAR(50) NOT NULL,
|
|
f_item_type VARCHAR(50),
|
|
f_item_id VARCHAR(50),
|
|
f_object_type VARCHAR(50),
|
|
f_object_id VARCHAR(50),
|
|
f_sort_code BIGINT,
|
|
f_creator_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_creator_user_id VARCHAR(50),
|
|
f_last_modify_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_last_modify_user_id VARCHAR(50),
|
|
f_delete_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_delete_user_id VARCHAR(50),
|
|
f_delete_mark INTEGER,
|
|
f_tenant_id VARCHAR(50) DEFAULT '0' NOT NULL,
|
|
f_org_id VARCHAR(50),
|
|
PRIMARY KEY (f_id, f_tenant_id)
|
|
);
|
|
|
|
-- ===== base_module ===== (source lines 2209-2240)
|
|
CREATE TABLE base_module (
|
|
f_id VARCHAR(50) NOT NULL,
|
|
f_parent_id VARCHAR(50),
|
|
f_type INTEGER,
|
|
f_full_name VARCHAR(200),
|
|
f_en_code VARCHAR(200),
|
|
f_category VARCHAR(50),
|
|
f_url_address VARCHAR(500),
|
|
f_icon VARCHAR(500),
|
|
f_link_target VARCHAR(50),
|
|
f_is_button_authorize INTEGER,
|
|
f_is_column_authorize INTEGER,
|
|
f_is_data_authorize INTEGER,
|
|
f_is_form_authorize INTEGER,
|
|
f_module_id VARCHAR(50),
|
|
f_system_id VARCHAR(50),
|
|
f_property_json TEXT,
|
|
f_description VARCHAR(500),
|
|
f_enabled_mark INTEGER,
|
|
f_sort_code BIGINT,
|
|
f_creator_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_creator_user_id VARCHAR(50),
|
|
f_last_modify_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_last_modify_user_id VARCHAR(50),
|
|
f_delete_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_delete_user_id VARCHAR(50),
|
|
f_delete_mark INTEGER,
|
|
f_tenant_id VARCHAR(50) DEFAULT '0' NOT NULL,
|
|
f_page_address VARCHAR(500),
|
|
f_no_show INTEGER DEFAULT 0,
|
|
PRIMARY KEY (f_id, f_tenant_id)
|
|
);
|
|
|
|
-- ===== base_organize ===== (source lines 3178-3201)
|
|
CREATE TABLE base_organize (
|
|
f_id VARCHAR(50) NOT NULL,
|
|
f_parent_id VARCHAR(50),
|
|
f_category VARCHAR(50),
|
|
f_en_code VARCHAR(200),
|
|
f_full_name VARCHAR(200),
|
|
f_manager_id VARCHAR(50),
|
|
f_property_json TEXT,
|
|
f_organize_id_tree TEXT,
|
|
f_description VARCHAR(500),
|
|
f_enabled_mark INTEGER,
|
|
f_sort_code BIGINT,
|
|
f_creator_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_creator_user_id VARCHAR(50),
|
|
f_last_modify_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_last_modify_user_id VARCHAR(50),
|
|
f_delete_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_delete_user_id VARCHAR(50),
|
|
f_delete_mark INTEGER,
|
|
f_tenant_id VARCHAR(50) DEFAULT '0' NOT NULL,
|
|
f_duty_position VARCHAR(50),
|
|
f_org_name_tree TEXT,
|
|
PRIMARY KEY (f_id, f_tenant_id)
|
|
);
|
|
|
|
-- ===== base_role ===== (source lines 3686-3707)
|
|
CREATE TABLE base_role (
|
|
f_id VARCHAR(50) NOT NULL,
|
|
f_full_name VARCHAR(200),
|
|
f_en_code VARCHAR(200),
|
|
f_type VARCHAR(50),
|
|
f_property_json TEXT,
|
|
f_global_mark INTEGER,
|
|
f_description VARCHAR(500),
|
|
f_enabled_mark INTEGER,
|
|
f_sort_code BIGINT,
|
|
f_creator_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_creator_user_id VARCHAR(50),
|
|
f_last_modify_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_last_modify_user_id VARCHAR(50),
|
|
f_delete_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_delete_user_id VARCHAR(50),
|
|
f_delete_mark INTEGER,
|
|
f_tenant_id VARCHAR(50) DEFAULT '0' NOT NULL,
|
|
f_is_condition INTEGER,
|
|
f_condition_json TEXT,
|
|
PRIMARY KEY (f_id, f_tenant_id)
|
|
);
|
|
|
|
-- ===== base_role_relation ===== (source lines 3729-3744)
|
|
CREATE TABLE base_role_relation (
|
|
f_id VARCHAR(50) NOT NULL,
|
|
f_role_id VARCHAR(50),
|
|
f_object_type VARCHAR(50),
|
|
f_object_id VARCHAR(50),
|
|
f_sort_code BIGINT,
|
|
f_creator_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_creator_user_id VARCHAR(50),
|
|
f_last_modify_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_last_modify_user_id VARCHAR(50),
|
|
f_delete_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_delete_user_id VARCHAR(50),
|
|
f_delete_mark INTEGER,
|
|
f_tenant_id VARCHAR(50) DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (f_id, f_tenant_id)
|
|
);
|
|
|
|
-- ===== base_user ===== (source lines 4479-4542)
|
|
CREATE TABLE base_user (
|
|
f_id VARCHAR(50) NOT NULL,
|
|
f_account VARCHAR(50),
|
|
f_real_name VARCHAR(50),
|
|
f_quick_query VARCHAR(100),
|
|
f_nick_name VARCHAR(50),
|
|
f_head_icon TEXT,
|
|
f_gender VARCHAR(50),
|
|
f_birthday TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_mobile_phone VARCHAR(20),
|
|
f_tele_phone VARCHAR(20),
|
|
f_landline VARCHAR(50),
|
|
f_email VARCHAR(50),
|
|
f_nation VARCHAR(50),
|
|
f_native_place VARCHAR(50),
|
|
f_entry_date TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_certificates_type VARCHAR(50),
|
|
f_certificates_number VARCHAR(50),
|
|
f_education VARCHAR(50),
|
|
f_urgent_contacts VARCHAR(50),
|
|
f_urgent_tele_phone VARCHAR(50),
|
|
f_postal_address VARCHAR(500),
|
|
f_signature VARCHAR(500),
|
|
f_password VARCHAR(50),
|
|
f_secretkey VARCHAR(50),
|
|
f_first_log_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_first_log_ip VARCHAR(50),
|
|
f_prev_log_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_prev_log_ip VARCHAR(50),
|
|
f_last_log_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_last_log_ip VARCHAR(50),
|
|
f_log_success_count INTEGER,
|
|
f_log_error_count INTEGER,
|
|
f_change_password_date TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_language VARCHAR(50),
|
|
f_theme VARCHAR(50),
|
|
f_is_administrator INTEGER,
|
|
f_manager_id VARCHAR(50),
|
|
f_organize_id VARCHAR(50),
|
|
f_position_id VARCHAR(50),
|
|
f_role_id TEXT,
|
|
f_portal_id TEXT,
|
|
f_lock_mark INTEGER,
|
|
f_unlock_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_group_id VARCHAR(50),
|
|
f_handover_mark INTEGER,
|
|
f_app_system_id VARCHAR(50),
|
|
f_description VARCHAR(500),
|
|
f_enabled_mark INTEGER,
|
|
f_sort_code BIGINT,
|
|
f_creator_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_creator_user_id VARCHAR(50),
|
|
f_last_modify_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_last_modify_user_id VARCHAR(50),
|
|
f_delete_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_delete_user_id VARCHAR(50),
|
|
f_delete_mark INTEGER,
|
|
f_tenant_id VARCHAR(50) DEFAULT '0' NOT NULL,
|
|
f_handover_userid VARCHAR(100),
|
|
f_rank VARCHAR(50),
|
|
f_standing VARCHAR(50),
|
|
f_app_standing VARCHAR(50),
|
|
PRIMARY KEY (f_id, f_tenant_id)
|
|
);
|
|
|
|
-- ===== base_user_relation ===== (source lines 4707-4722)
|
|
CREATE TABLE base_user_relation (
|
|
f_id VARCHAR(50) NOT NULL,
|
|
f_user_id VARCHAR(50),
|
|
f_object_type VARCHAR(50),
|
|
f_object_id VARCHAR(50),
|
|
f_sort_code BIGINT,
|
|
f_creator_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_creator_user_id VARCHAR(50),
|
|
f_last_modify_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_last_modify_user_id VARCHAR(50),
|
|
f_delete_time TIMESTAMP(0) WITHOUT TIME ZONE,
|
|
f_delete_user_id VARCHAR(50),
|
|
f_delete_mark INTEGER,
|
|
f_tenant_id VARCHAR(50) DEFAULT '0' NOT NULL,
|
|
PRIMARY KEY (f_id, f_tenant_id)
|
|
);
|
|
|