ERD_psw
Tables (6)
t_ARCHLOGIN (Untitled6)
- loginid — varchar2(20) — Primary key
- pass — varchar2(20)
t_JOBHISTORY (Untitled5)
- exec_date — date — Primary key — NOT NULL
- schedname — varchar2(40) — Foreign key → t_SCHEDULE.schedname — NOT NULL
- jobname — varchar2(40) — Foreign key → t_SCHEDULE.jobname — NOT NULL
- srvname (src_srvname) — varchar2(20) — Foreign key → t_SCHEDULE.srvname — NOT NULL
- userid (src_userid) — varchar2(20) — Foreign key → t_SCHEDULE.userid — NOT NULL
- groupname (src_groupname) — varchar2(40) — Foreign key → t_SCHEDULE.groupname — NOT NULL
- success — boolean
- starttime — date
- enddate — date
t_JOBPOLICY (Untitled3)
- jobname — varchar2(40) — Primary key — NOT NULL
- srvname (src_srvname) — varchar2(20) — Foreign key → t_SRC_CONNINFO.srvname — NOT NULL
- userid (src_userid) — varchar2(20) — Foreign key → t_SRC_CONNINFO.userid — NOT NULL
- groupname (src_groupname) — varchar2(40) — Foreign key → t_SRC_CONNINFO.groupname — NOT NULL
- src_tablename — varchar2(100) — NOT NULL
- tar_tablespace — varchar2(100) — NOT NULL
- regdate — date
- autopurge — boolean — NOT NULL
- confirm — boolean — NOT NULL
- script — varchar2(5000)
- description — varchar2(100)
t_SCHEDULE (Untitled4)
- schedname — varchar2(40) — Primary key — NOT NULL
- jobname — varchar2(40) — Foreign key → t_JOBPOLICY.jobname — NOT NULL
- srvname (src_srvname) — varchar2(20) — Foreign key → t_JOBPOLICY.srvname — NOT NULL
- userid (src_userid) — varchar2(20) — Foreign key → t_JOBPOLICY.userid — NOT NULL
- groupname (src_groupname) — varchar2(40) — Foreign key → t_JOBPOLICY.groupname — NOT NULL
- specificdate — date
- recursive — boolean
- recur_cycle — varchar2(10)
- schedtime — varchar2(30)
t_SRC_CONNINFO (Untitled)
- srvname — varchar2(20) — Primary key — NOT NULL
- userid — varchar2(20) — Primary key — NOT NULL
- groupname — varchar2(40) — Foreign key → t_SRC_GROUP.groupname — NOT NULL
- passwd — varchar2(20)
- ipaddr — varchar2(20) — NOT NULL
- port — varchar2(10) — NOT NULL
- savepass — boolean — NOT NULL
- type — varchar2(1)
t_SRC_GROUP (Untitled2)
- groupname — varchar2(40) — Primary key — NOT NULL
- parentlvl — number — NOT NULL
- currentlvl — number — NOT NULL
- type — varchar2(1) — NOT NULL