test
Tables (28)
ATTACHMENT
- ATTACHMENTNO — VARCHAR(255) — Primary key — NOT NULL
- BOARDNO — NUMBER — Foreign key → BOARD.BOARDNO — NOT NULL
- ORIGINALFILENAME — VARCHAR(255)
- RENAMEDFILENAME — VARCHAR(255)
- UPLOADDATE — VARCHAR(255)
- DOWNLOADCOUNT — VARCHAR(255)
- STATUS — VARCHAR(255)
ATTENDANCE
- IDCODE — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- DCODE2 — NUMBER — Foreign key → EMPLOYEE.DCODE — NOT NULL
- VSTATUS — NUMBER
- ABSENCE — NUMBER
BOARD
- BOARDNO — NUMBER — Primary key — NOT NULL
- IDCODE — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- BOARDTITLE — VARCHAR2
- BOARDWRITER — VATCHAR2
- BOARDCONTENT — NUMBER
- BOARDDATE — DATE
- BOARDREADCOUNT — NUMBER
CHAT
- CHCODE — NUMBER — Foreign key → CHATROOM.CHCODE — NOT NULL
- IDCODE — NUMBER — Foreign key → ROOMMEMBER.IDCODE — NOT NULL
- CHATDETAIL — VARCHAR2
- CHATTIME — TIMESTAMP
CHATROOM
- CHCODE — NUMBER — Primary key — NOT NULL
- CHNAME — STRING
DEPARTMENT
- DCODE — NUMBER — Primary key — NOT NULL
- ECODE — NUMBER — Foreign key → ENTERPRISE.ECODE — NOT NULL
- DTITLE — VARCHAR2
EMPLOYEE
- IDCODE — NUMBER — Primary key — NOT NULL
- DCODE — VARCHAR — Foreign key → DEPARTMENT.DCODE — NOT NULL
- WPWD — VARCHAR2
- WNAME — VARCHAR2
- POSITION — VARCHAR2
- ENROLLDATE — DATE
- WSTATUS — CHAR
- RETIREDATE — DATE
- IDCODE2 — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- DCODE2 — VARCHAR — Foreign key → EMPLOYEE.DCODE — NOT NULL
ENTERPRISE
- ECODE — NUMBER — Primary key — NOT NULL
- EID — VARCHAR2
- EPWD — VARCHAR2
- ENAME — VARCHAR2
- ENO — NUMBER
- EEMAIL — VARCHAR2
- EADDRESS — VARCHAR2
- EPHONE — VARCHAR2
- EDIVISION — VARCHAR
- ESTATUS — VARCHAR2
- ENT_OUT_DATE — DATE
FIELD
- FCODE — NUMBER — Primary key — NOT NULL
- ECODE — NUMBER — Foreign key → DEPARTMENT.ECODE — NOT NULL
- DCODE — NUMBER — Foreign key → DEPARTMENT.DCODE — NOT NULL
- FNAME — VARCHAR2
- FAREA — VARCHAR2
- FPART — VARCHAR(255)
JOB_ORDER
- WORKCODE — VARCHAR — Primary key — NOT NULL
- IDCODE — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- PCODE — NUMBER — Foreign key → PRODUCT.PCODE — NOT NULL
- FCODE — NUMBER — Foreign key → FIELD.FCODE — NOT NULL
- ORDERDATE — DATE
- WSTATUS — CHAR
- PRODUCTEA — NUMBER
- Field2 — VARCHAR(255)
- Field — VARCHAR(255)
MATERIALS
- MCODE — NUMBER — Primary key — NOT NULL
- MCATE — NUMBER — Foreign key → MATERIALS_CATEGORY.MCATE — NOT NULL
- MNAME — VARCHAR
MATERIALS_CATEGORY
- MCATE — NUMBER — Primary key — NOT NULL
- MCNAME — VARCHAR
M_STORAGE
- 발주번호 — NUMBER — Primary key — NOT NULL
- 받을 — 창고코드` — Primary key — NOT NULL
- 사원코드 — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- 기자재코드 — NUMBER — Foreign key → MATERIALS.MCODE — NOT NULL
- MSMSTOCK — VARCHAR
- MSDATE — DATE
- MSPRICE — (완료일때채워짐)NUMBER
- MSSTATUS — VARCHAR2
PARTNER
- PARTNERC — NUMBER — Primary key — NOT NULL
- ECODE — NUMBER — Foreign key → ENTERPRISE.ECODE — NOT NULL
- PARNAME — VARCHAR2
- PARSTS — CHAR
PMANAGEMENT
- IDCODE — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- DCODE2 — NUMBER — Foreign key → EMPLOYEE.DCODE — NOT NULL
- PAYMENT — DATE
- MINCOME — NUMBER
PRODUCT
- PCODE — NUMBER — Primary key — NOT NULL
- PCATE — VARCHAR — Foreign key → PRODUCT_CATEGORY.PCATE — NOT NULL
- PNAME — VARCHAR
- PSIZE — VARCHAR
- PBARCODE — NUMBER
PRODUCT_CATEGORY
- PCATE — VARCHAR — Primary key — NOT NULL
- PCNAME — VARCHAR
PURCHASE
- BUY_CODE — NUMBER — Primary key — NOT NULL
- IDCODE — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- PARTNERC — NUMBER — Foreign key → PARTNER.PARTNERC — NOT NULL
- ECODE — NUMBER — Foreign key → PARTNER.ECODE — NOT NULL
- BUY_DAY — DATE
PURCHASE_ITEM
- BUY_CODE — NUMBER — Foreign key → PURCHASE.BUY_CODE — NOT NULL
- SCODE — NUMBER — Foreign key → STORAGE_DETAIL.SCODE — NOT NULL
- MCODE — NUMBER — Foreign key → STORAGE_DETAIL.MCODE — NOT NULL
- PCODE — NUMBER — Foreign key → STORAGE_DETAIL.PCODE — NOT NULL
- IDCODE — NUMBER — Foreign key → STORAGE_DETAIL.IDCODE — NOT NULL
- ECODE — NUMBER — Foreign key → STORAGE_DETAIL.ECODE — NOT NULL
- WORKCODE — VARCHAR — Foreign key → STORAGE_DETAIL.WORKCODE — NOT NULL
- BUY_AMOUNT — NUMBER
- BUY_ORIGIN — NUMBER
- BUY_PRICE — NUMBER
- BUY_STATUS — CHAR
QUALITY_CH
- QRCODE — NUMBER — Foreign key → QUALITY_R.QRCODE — NOT NULL
- ECODE — NUMBER — Foreign key → QUALITY_R.ECODE — NOT NULL
- WORKCODE — VARCHAR — Foreign key → QUALITY_R.WORKCODE — NOT NULL
- QCHT — NUMBER
- QCHF — NUMBER
- QCHCHECK — VARCHAR
- QCHSTATUS — VARCHAR
QUALITY_R
- QRCODE — NUMBER — Primary key — NOT NULL
- IDCODE — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- SCODE — NUMBER — Foreign key → STORAGE_DETAIL.SCODE — NOT NULL
- PCODE — NUMBER — Foreign key → STORAGE_DETAIL.PCODE — NOT NULL
- ECODE — NUMBER — Foreign key → STORAGE_DETAIL.ECODE — NOT NULL
- WORKCODE — VARCHAR — Foreign key → STORAGE_DETAIL.WORKCODE — NOT NULL
- QRCHECK — VARCHAR
- QRNOTE — VARCHAR
- QRSTOCK — NUMBER
- QRSTATUS — VARCHAR
ROOMMEMBER
- CHCODE — NUMBER — Foreign key → CHATROOM.CHCODE — NOT NULL
- IDCODE — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
SALE
- SAL_CODE — NUMBER — Primary key — NOT NULL
- ECODE — NUMBER — Foreign key → PARTNER.ECODE — NOT NULL
- PARTNERC — NUMBER — Foreign key → PARTNER.PARTNERC — NOT NULL
- IDCODE — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- SALDAY — DATE
SALEITEM
- SAL_CODE — NUMBER — Foreign key → SALE.SAL_CODE — NOT NULL
- SCODE — NUMBER — Foreign key → STORAGE.SCODE — NOT NULL
- MCODE — NUMBER — Foreign key → MATERIALS.MCODE — NOT NULL
- PCODE — NUMBER — Foreign key → PRODUCT.PCODE — NOT NULL
- PCATE — VARCHAR — Foreign key → PRODUCT.PCATE — NOT NULL
- SAL_NAME — NUMBER
- SAL_AMOUNT — NUMBER
- SAL_PRICE — NUMBER
- SAL_PROFIT — NUMBER
- SAL_STATUS — CHAR
- SAL_DISCOUNT — NUMBER
SCHEDULING
- SC_ID — VARCHAR(255) — Primary key — NOT NULL
- IDCODE — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- SC_TITLE — VARCHAR(255)
- SC_DETAIL — VARCHAR(255)
- SC_START — VARCHAR(255)
- SC_END — VARCHAR(255)
- SC_ALLDAY — VARCHAR(255)
STORAGE
- SCODE — NUMBER — Primary key — NOT NULL
- ECODE — NUMBER — Foreign key → ENTERPRISE.ECODE — NOT NULL
- IDCODE — NUMBER — Foreign key → EMPLOYEE.IDCODE — NOT NULL
- SCATE — VARCHAR
- SPHONE — VARCHAR
- SADDR — VARCHAR
- SSTATUS — VARCHAR
STORAGE_DETAIL
- SDCODE — NUMBER — Primary key — NOT NULL
- SCODE — NUMBER — Foreign key → STORAGE.SCODE — NOT NULL
- IDCODE — NUMBER — Foreign key → STORAGE.IDCODE — NOT NULL
- ECODE — NUMBER — Foreign key → ENTERPRISE.ECODE — NOT NULL
- MCODE — NUMBER — Foreign key → MATERIALS.MCODE — NOT NULL
- PCODE — NUMBER — Foreign key → PRODUCT.PCODE — NOT NULL
- WORKCODE — VARCHAR — Foreign key → JOB_ORDER.WORKCODE — NOT NULL
- SDSTOCK — NUMBER
- SDCOST — NUMBER
- SDPRICE — NUMBER
- SDDATE — DATE
VACATION
- VNAME — NUMBER
- VDATE — NUMBER
- VTOTAL — NUMBER