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