SCM开发年份、季节档案设计文档
1、背景介绍
SCM开发年份、季节档案基础数据，由于数据变动可能性低，数据按SCM进行初始化和更新，FMS实时同步数据。
3、表结构设计
测试环境
- 年份档案
| 字段名 | 数据类型 | 是否非空 | 默认值 | 备注 |
|---|---|---|---|---|
| id | int | 是 | NULL | 主键 |
| years_code | varchar(64) | 是 | NULL | 年份代码 |
| years | int(32) | 是 | NULL | 年份 |
| enables | smallint | 是 | 1 | 启用 1 禁用 0 |
| deleted | smallint | 是 | 0 | 删除 1 未删除 0 |
| remark | varchar(255) | 否 | NULL | 备注 |
| created | timestamp | 是 | NULL | 创建时间 |
| create_user | varchar(45) | 是 | NULL | 创建人 |
| last_updated | timestamp | 否 | NULL | 更新时间(维护时间) |
| last_update_user | varchar(45) | 否 | NULL | 更新人(维护人) |
| last_update_user_id | int(64) | 否 | NULL | 更新人ID(维护人ID) |
- 季节档案
| 字段名 | 数据类型 | 是否非空 | 默认值 | 备注 |
|---|---|---|---|---|
| id | int | 是 | NULL | 主键 |
| season_code | varchar(64) | 是 | NULL | 年份代码 |
| season | int(32) | 是 | NULL | 年份 |
| enables | smallint | 是 | 1 | 启用 1 禁用 0 |
| deleted | smallint | 是 | 0 | 删除 1 未删除 0 |
| remark | varchar(255) | 否 | NULL | 备注 |
| created | timestamp | 是 | NULL | 创建时间 |
| create_user | varchar(45) | 是 | NULL | 创建人 |
| last_updated | timestamp | 否 | NULL | 更新时间(维护时间) |
| last_update_user | varchar(45) | 否 | NULL | 更新人(维护人) |
| last_update_user_id | int(64) | 否 | NULL | 更新人ID(维护人ID) |
3、初始化数据
- 年份
INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (20, 'P', 2035, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (21, 'Q', 2036, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (22, 'R', 2037, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (23, 'S', 2038, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (24, 'T', 2039, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (25, 'U', 2040, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (26, 'V', 2041, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (27, 'W', 2042, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (28, 'X', 2043, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (29, 'Y', 2044, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (30, 'Z', 2045, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (1, '6', 2016, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (2, '7', 2017, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (3, '8', 2018, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (4, '9', 2019, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (5, 'A', 2020, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (6, 'B', 2021, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (7, 'C', 2022, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (8, 'D', 2023, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (9, 'E', 2024, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (10, 'F', 2025, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (11, 'G', 2026, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (12, 'H', 2027, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (13, 'I', 2028, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (14, 'J', 2029, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (15, 'K', 2030, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (16, 'L', 2031, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (17, 'M', 2032, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (18, 'N', 2033, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); INSERT INTO basic_year(id, years_basic_brand, years, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (19, 'O', 2034, 1, 0, '2020-05-31 02:00:02.253', '系统', '系统', NULL, '2023-04-05 02:00:00.916', NULL); - 季节
INSERT INTO basic_season(id, season_basic_brand, season, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (1, 'A', '春季', 1, 0, '2020-05-31 02:01:40.524', '汪归', '系统', NULL, '2023-04-05 02:00:00.958', NULL); INSERT INTO basic_season(id, season_basic_brand, season, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (2, 'B', '夏季', 1, 0, '2020-05-31 02:01:40.524', '汪归', '系统', NULL, '2023-04-05 02:00:00.958', NULL); INSERT INTO basic_season(id, season_basic_brand, season, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (3, 'C', '秋季', 1, 0, '2020-05-31 02:01:40.524', '汪归', '系统', NULL, '2023-04-05 02:00:00.958', NULL); INSERT INTO basic_season(id, season_basic_brand, season, enable, deleted, created, create_user, last_update_user, last_update_user_id, last_updated, remark) VALUES (4, 'D', '冬季', 1, 0, '2020-05-31 02:01:40.524', '汪归', '系统', NULL, '2023-04-05 02:00:00.958', NULL);