任务计划表结构
3.23 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
create table appdata.SLIS_BATCH_PLAN
(
sequence VARCHAR2(20) not null,
proc_code VARCHAR2(4),
branch_code VARCHAR2(10),
parameters VARCHAR2(2000),
scheduled_start_date DATE,
priority INTEGER,
proc_flag VARCHAR2(2),
create_date DATE,
create_user VARCHAR2(100),
fcu VARCHAR2(100),
fcd DATE,
lcu VARCHAR2(100),
lcd DATE,
job_no NUMBER,
job_source_module VARCHAR2(4),
start_date DATE,
end_date DATE
)
comment on table appdata.SLIS_BATCH_PLAN
is '任务计划表';
-- Add comments to the columns
comment on column appdata.SLIS_BATCH_PLAN.sequence
is '流水号';
comment on column appdata.SLIS_BATCH_PLAN.proc_code
is '批处理代码';
comment on column appdata.SLIS_BATCH_PLAN.branch_code
is '机构代码';
comment on column appdata.SLIS_BATCH_PLAN.parameters
is '批处理参数';
comment on column appdata.SLIS_BATCH_PLAN.scheduled_start_date
is '任务计划启动时间';
comment on column appdata.SLIS_BATCH_PLAN.priority
is '优先级';
comment on column appdata.SLIS_BATCH_PLAN.proc_flag
is '批处理状态';
comment on column appdata.SLIS_BATCH_PLAN.create_date
is '写入时间';
comment on column appdata.SLIS_BATCH_PLAN.create_user
is '写入用户';
comment on column appdata.SLIS_BATCH_PLAN.fcu
is '创建人';
comment on column appdata.SLIS_BATCH_PLAN.fcd
is '创建日期';
comment on column appdata.SLIS_BATCH_PLAN.lcu
is '修改人';
comment on column appdata.SLIS_BATCH_PLAN.lcd
is '修改日期';
comment on column appdata.SLIS_BATCH_PLAN.job_no
is 'job号';
comment on column appdata.SLIS_BATCH_PLAN.job_source_module
is 'job模块号';
comment on column appdata.SLIS_BATCH_PLAN.start_date
is '任务起始时间';
comment on column appdata.SLIS_BATCH_PLAN.end_date
is '任务结束时间(不精确,间隔时间越大差异越大)';
create table rendata.RN_ASSIGN_BATCH_RECORD
branch_code VARCHAR2(10) not null,
due_month DATE not null,
batch_code VARCHAR2(20) not null,
batch_seq VARCHAR2(20),
finish_flag VARCHAR2(1),
pk_serial VARCHAR2(20) not null,
created_user VARCHAR2(100) not null,
created_date DATE default sysdate not null,
updated_user VARCHAR2(100) not null,
updated_date DATE default sysdate not null
comment on table rendata.RN_ASSIGN_BATCH_RECORD
is '机构分单批次申请记录表';
-- Add comments to the columns
comment on column rendata.RN_ASSIGN_BATCH_RECORD.due_month
is '应缴月';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.batch_code
is '批处理代码';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.batch_seq
is '批处理流水';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.finish_flag
is '完成状态';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.pk_serial
is '数据主键';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.created_user
is '录入人';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.created_date
is '录入日期';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.updated_user
is '修改人';
comment on column rendata.RN_ASSIGN_BATCH_RECORD.updated_date
is '修改日期';