-- Table rpt_offline
CREATE TABLE user1.rpt_offline
(rpt_id NUMBER(10,0) NOT NULL,
rpt_code VARCHAR2(100 BYTE),
rpt_name VARCHAR2(500 BYTE),
pc VARCHAR2(20 BYTE),
status NUMBER(1,0),
create_date DATE NOT NULL,
excel_param VARCHAR2(500 BYTE),
excel_template VARCHAR2(500 BYTE),
file_export VARCHAR2(500 BYTE),
execute_date DATE,
sql_param VARCHAR2(500 BYTE),
sql_template CLOB,
description VARCHAR2(4000 BYTE),
ftp_ip VARCHAR2(30 BYTE),
ftp_port VARCHAR2(10 BYTE),
ftp_user VARCHAR2(50 BYTE),
ftp_pass VARCHAR2(100 BYTE));
-- Indexes for RPT_OFFLINE
CREATE INDEX user1.ro_i1 ON cor_owner.rpt_offline
(
user_name ASC
);
-- Constraints for RPT_OFFLINE
ALTER TABLE user1.rpt_offline
ADD CONSTRAINT pk_ro PRIMARY KEY (rpt_id);
-- Sequence rpt_offline_seq
CREATE SEQUENCE user1.rpt_offline_seq
INCREMENT BY 1
START WITH 1
MINVALUE 1
MAXVALUE 99999999999999999
NOCYCLE
NOORDER
CACHE 20
;
