Files
adminandClaude 0aed12a102 docs: 契约规格 + 实施计划 + 官方 base_* DDL 原文
- 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]>
2026-10-25 17:05:00 +08:00

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)
);