사업장관리프로그램
테이블 (16)
CHATROOM
- c_no — number
- room_id — varchar2(255) — NOT NULL
- title — varchar2(50) — NOT NULL
- owner — varchar2(50) — NOT NULL
- users — clob — NOT NULL
- delchk — number(1) — NOT NULL
- channel — varchar2(25) — NOT NULL
- reg_date — date — NOT NULL
COMPANY
- C_IDX — NUMBER
- G_CODE_KEY — VARCHAR2(20) — NOT NULL
- C_NAME — VARCHAR2(100) — NOT NULL
- C_LATITUDE — NUMBER(8,6) — NOT NULL
- C_LONGITUDE — NUMBER(9,6) — NOT NULL
- C_REG_DATE — DATE
COMPANY_AREA
- CA_IDX — NUMBER
- G_CODE_KEY — varchar2(25) — NOT NULL
- CA_CODE — varchar2(25) — NOT NULL
- OMS_CODE — varchar2(25)
- NAME — varchar2(50)
- LATITUDE — VARCHAR2(255)
- LONGITUDE — VARCHAR2(255)
- CHEMICALS — clob
- reg_date — date
COMPANY_DISTILL
- CD_IDX — NUMBER
- G_CODE_KEY — VARCHAR2(25) — NOT NULL
- CD_CODE — VARCHAR2(25) — NOT NULL
- OMS_CODE — VARCHAR2(25)
- NAME — VARCHAR2(50)
- LATITUDE — NUMBER(12,7)
- LONGITUDE — NUMBER(12,7)
- CHEMICALS — CLOB
- REG_DATE — DATE
COMPANY_GROUP
- group_no — NUMBER
- g_code_key — VARCHAR2(20) — NOT NULL
- g_name — varchar2(50) — NOT NULL
- g_manager — varchar(50) — NOT NULL
- g_url — varchar2(100)
- g_ip — varchar(25)
- g_reg_date — date — NOT NULL
COMPANY_PLANT
- p_idx — number
- g_code_key — varchar2(10) — NOT NULL
- p_type — varchar2(25) — NOT NULL
- p_name — varchar2(255)
- p_chemicals — clob
- p_users — clob
- p_manager — varchar2(50)
- p_reg_date — date — NOT NULL
COMPANY_POINT
- cp_idx — number
- g_code_key — varchar2(25) — NOT NULL
- cp_code — varchar2(25)
- oms_code — varchar2(25)
- name — varchar2(50) — NOT NULL
- latitude — number(12,7)
- longitude — number(12,7)
- height — float
- stack_height — float
- stack_round — float
- temprature — float
- flow — float
- oxgen — float
- moisture — float
- speed — float
- chemicals — clob
- reg_date — DATE
COMPANY_SEWAGE
- CS_IDX — NUMBER
- G_CODE_KEY — VARCHAR2(25) — NOT NULL
- CS_CODE — VARCHAR2(25) — NOT NULL
- OMS_CODE — VARCHAR2(25)
- NAME — VARCHAR2(50)
- LATITUDE — NUMBER(12,7)
- LONGITUDE — NUMBER(12,7)
- CHEMICALS — CLOB
- REG_DATE — DATE
COMPANY_TANK
- CT_IDX — NUMBER
- G_CODE_KEY — VARCHAR2(25) — NOT NULL
- CT_CODE — VARCHAR2(25) — NOT NULL
- OMS_CODE — VARCHAR2(25)
- NAME — VARCHAR2(50)
- LATITUDE — NUMBER(12,7)
- LONGITUDE — NUMBER(12,7)
- CHEMICALS — CLOB
- REG_DATE — DATE
COMPANY_WASHTOWER
- CW_IDX — NUMBER
- G_CODE_KEY — VARCHAR2(25) — NOT NULL
- CW_CODE — VARCHAR2(25) — NOT NULL
- OMS_CODE — VARCHAR2(25)
- NAME — VARCHAR2(50)
- LATITUDE — NUMBER(12,7)
- LONGITUDE — NUMBER(12,7)
- CHEMICALS — CLOB
- REG_DATE — DATE
MEMBER
- U_IDX — NUMBER
- G_CODE_KEY — VARCHAR2(10) — NOT NULL
- USER_ID — VARCHAR2(100) — NOT NULL
- USER_PW — VARCHAR2(255) — NOT NULL
- USER_NAME — VARCHAR2(25) — NOT NULL
- USER_PERMIT — VARCHAR2(1) — NOT NULL
- USER_GRADE — VARCHAR2(1) — NOT NULL
- USER_DELCHK — NUMBER(1) — NOT NULL
- USER_CODE — VARCHAR2(20)
- USER_REG_DATE — DATE
OMS_DATA
- NO — NUMBER
- G_CODE_KEY — VARCHAR2(25) — NOT NULL
- OMS_CODE — VARCHAR2(25) — NOT NULL
- SEN1 — FLOAT
- SEN2 — FLOAT
- SEN3 — FLOAT
- SEN4 — FLOAT
- SEN5 — FLOAT
- SEN6 — FLOAT
- SEN7 — FLOAT
- SEN8 — FLOAT
- SEN9 — FLOAT
- SEN10 — FLOAT
- SEN11 — FLOAT
- SEN12 — FLOAT
- SEN13 — FLOAT
- SEN14 — FLOAT
- SMELL — VARCHAR2(25)
- STRENGTH — NUMBER(1)
- OOU — NUMBER
- REG_DATE — DATE
OMS_INFO
- OI_IDX — NUMBER
- G_CODE_KEY — VARCHAR2(25)
- OI_CODE — VARCHAR2(25)
- NAME — VARCHAR2(25)
- LATITUDE — NUMBER(12,7)
- LONGITUDE — NUMBER(12,7)
- REG_DATE — DATE
SMELL
- S_IDX — NUMBER
- S_CODE_KEY — VARCHAR2(10) — NOT NULL
- S_NAME — VARCHAR2(30) — NOT NULL
- S_REG_DATE — DATE — NOT NULL
SMELL_INFO
- NO — NUMBER
- CODE — VARCHAR2(5)
- NAME — VARCHAR2(25)
schedule
- s_no — number
- notice — varchar2(20) — NOT NULL
- owner — varchar2(50) — NOT NULL
- title — varchar2(250) — NOT NULL
- content — clob — NOT NULL
- delchk — number(1) — NOT NULL
- views — number — NOT NULL
- reg_date — DATE — NOT NULL