111

Tables (30)

APPRAOVAL

  • A_NO — NUMBER — Primary key — NOT NULL
  • A_R_NO — NUMBER — NOT NULL
  • D_C_I_NO — NUMBER — NOT NULL
  • A_DATE — DATE
  • A_EXPERAIONDATE — DATE
  • A_PIC_APPRAOVAL_NY — CHAR
  • A_TEAM_APPRAOVAL_NY — CHAR
  • A_DECISION_APPRAOVAL_NY — CHAR
  • A_ALLDECISION_APPRAOVAL_NY — CHAR
  • A_STATEMENT — VARCHAR2(100)

APPRAOVAL_REGULATION

  • A_R_NO — NUMBER — Primary key — NOT NULL
  • JOP_TITLE_DECISION_CODE — VARCHAR2(10) — NOT NULL
  • JOP_TITLE_ALLDECISION_CODE — VARCHAR2(10) — NOT NULL
  • D_C_CODE — NUMBER — NOT NULL

BOARD

  • BOARD_NO — NUMBER — Primary key — NOT NULL
  • EMPLOYEE_NO — NUMBER — NOT NULL
  • BOARD_TITLE — VARCHAR2(50)
  • BOARD_CONTENTS — LONG
  • BOARD_VIEWS — NUMBER
  • BOARD_DELETE — CHAR(1)
  • BOARD_DATE — DATE
  • BOARD_CATEGORY — VARCHAR2(5)

BOARD_IMG

  • BOARD_NO — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
  • NUMBER — NUMBER
  • IMG_NAME1 — VARCHAR2(500)
  • IMG_NAME2 — VARCHAR2(500)
  • IMG_NAME3 — VARCHAR2(500)
  • SERVER_NAME1 — VARCAHR2(1000)
  • SERVER_NAME2 — VARCHAR2(1000)
  • SERVER_NAME3 — VARCHAR2(1000)
  • IMG_ROUTE — VARCHAR2(300)

CLIENT

  • C_NO — NUMBER — Primary key — NOT NULL
  • C_NAME — VARCHAR2(100)
  • B_NO — NUMBER
  • C_TYPE — VARCHAR2(100)
  • C_OWNER — VARCHAR2(100)
  • C_ADDR — VARCHAR2(100)
  • C_PHONE — NUMBER
  • C_FAX — NUMBER
  • C_EMAIL — VARCHAR2(100)
  • C_PIC — VARCHAR2(100)
  • C_UMONY — NUMBER
  • Field — NUMBER
  • Field2 — NUMBER

CLIENT_LOG

  • C_LOG_NO — NUMBER — Primary key — NOT NULL
  • C_NO — NUMBER — NOT NULL
  • C_DATE — DATE
  • C_AMOUNT — NUMBER
  • C_NOTE — VARCHAR2(100)

COMMENT

  • COMMENT_NO — NUMBER — Primary key — NOT NULL
  • BOARD_NO — NUMBER — NOT NULL
  • EMPLOYEE_NO — NUMBER — NOT NULL
  • COMMENT_CONTENTS — VARCHAR2(4000)
  • COMMENT_DATE — DATE
  • COMMENT_REPLY — CHAR(1)
  • COMMENT_DELETE — CHAR(1)

CopyOfUntitled

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • O_NO — NUMBER — NOT NULL

CopyOfUntitled2

  • Key — VARCHAR(255) — Foreign key → CopyOfUntitled.Key — NOT NULL
  • P_NO — NUMBER — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)

DEPARTMENT

  • DEPART_CODE — VARCHAR2(10) — Primary key — NOT NULL
  • DEPART_NAME — VARCHAR2(20)

DEPOSIT

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • C_NO — NUMBER — NOT NULL
  • PROJECT_NO — NUMBER — NOT NULL
  • D_DATE — DATE
  • ACCOUNT — NUMBER
  • D_BANK — VARCHAR2
  • D_MONEY — NUMBER

DOCUMENT_CATEGORY

  • D_C_CODE — NUMBER — Primary key — NOT NULL
  • D_C_NAME — VARCHAR2(100)

DOCUMENT_IMAGE

  • D_I_NO — NUBMER — Primary key — NOT NULL
  • A_NO — NUMBER — NOT NULL
  • D_I_ROUTE — VARCHAR2(500)
  • D_NO — NUMBER
  • D_I_PIC — VARCHAR(255)
  • TEAMCODE — VARCHAR(255)

DRAFT

  • D_NO — NUMBER — Primary key — NOT NULL
  • C_NO — NUMBER — NOT NULL
  • PROJECT_NO — NUMBER — NOT NULL
  • D_CODE — VARCHAR(100)
  • E_DATE — DATE
  • D_PAYEMENTDATE — DATE
  • D_VALIDITY — DATE
  • D_TERMS — VARCHAR2(100)
  • D_DELIVERY_PLACE — VARCHAR2(100)
  • D_NOTE — VARCHAR2(300)
  • D_PIC — VARCHAR2(100) — NOT NULL
  • O_NO — NUMBER — NOT NULL
  • D_WAREHOUSE_NO — VARCHAR2(100) — NOT NULL
  • TEAM_CODE — VARCHAR2(10) — NOT NULL

EMPLOYEE

  • EMPLOYEE_NO — NUMBER — Primary key — NOT NULL
  • EMPLOYEE_ID — VARCHAR2(20)
  • EMPLOYEE_PWD — VARCHAR2(300)
  • EMPLOYEE_NAME — VARCHAR2(10)
  • EMPLOYEE_BIRT — DATE
  • EMPLOYEE_ADDR — VARCHAR2(100)
  • EMPLOYEE_PHONE — VARCHAR2(20)
  • EMPLOYEE_EMAIL — VARCHAR2(30)
  • HIRE_DATE — DATE
  • FIRE_DATE — DATE
  • JOP_POSITION — VARCHAR2(10)
  • JOP_TITLE_CODE — VARCHAR2(10) — NOT NULL
  • TEAM_CODE — VARCHAR2(10) — NOT NULL
  • ENT_YN — CHAR

ESTIMATE

  • E_NO — NUMBER — Primary key — NOT NULL
  • C_NO — NUMBER — NOT NULL
  • PROJECT_NO — NUMBER — NOT NULL
  • EMPLOYEE_NO — NUMBER — NOT NULL
  • E_WRITINGDATE — DATE
  • Field5 — VARCHAR2(100)
  • E_TERMS — VARCHAR2(100)
  • E_VALIDITY — DATE
  • NUMBER — NUMBER
  • WAREHOUSE_NO — NUMBER — NOT NULL
  • TEAM_CODE — VARCHAR2(10) — NOT NULL

ESTIMATE_FILE

  • NUMBER — NUMBER
  • FILE_NAME — VARCHAR2(500)
  • SERVER_NAME — VARCAHR2(1000)
  • FILE_PATH — VARCHAR2(300)

GROUP

  • GROUP_NO — NUMBER — Primary key — NOT NULL
  • EMPLOYEE_NO — NUMBER — NOT NULL
  • PROJECT_NO — NUMBER — NOT NULL
  • GROUP_POSITION — VARCHAR(20)

JOPTITLE

  • JOP_TITLE_CODE — VARCHAR2(10) — Primary key — NOT NULL
  • JOP_TITLE_NAME — VARCHAR2(10)

MAIL

  • MAIL_NO — NUMBER — Primary key — NOT NULL
  • MAIL_TITLE — VARCHAR2(100)
  • MAIL_CONTENT — VARCHAR2(2000)
  • RECIPIENT — NUMBER — NOT NULL
  • SENDER — NUMBER — NOT NULL
  • MAIL_DATE — DATE
  • READ_YN — CHAR

MAILFILE

  • MAIL_NO — NUMBER — Foreign key → MAIL.MAIL_NO — NOT NULL
  • MAIL_FILE_NO — NUMBER
  • FILE_NAME1 — VARCHAR(100)
  • FILE_NAME2 — VARCHAR(100)
  • FILE_NAME3 — VARCHAR(100)
  • FILE_SERVER_NAME1 — VARCHAR(100)
  • FILE_SERVER_NAME2 — VARCHAR(100)
  • FILE_SERVER_NAME3 — VARCHAR(100)
  • FILE_PATH — VARCHAR(100)

ORDER

  • O_NO — NUMBER — Primary key — NOT NULL
  • C_NO — NUMBER — NOT NULL
  • PROJECT_NO — NUMBER — NOT NULL
  • EMPLOYEE_NO — NUMBER — NOT NULL
  • E_NO — NUMBER — NOT NULL
  • WAREHOUSE_NO — NUMBER — NOT NULL
  • O_WRITINGDATE — DATE
  • O_CONDITION — VARCHAR2(200)
  • O_DATE — DATE
  • O_EXP_DEL_DATE — DATE
  • O_FILE_PATH — VARCHAR2(300)
  • TEAM_CODE — VARCHAR2(10) — NOT NULL

PRODUCT

  • P_NO — NUMBER — Primary key — NOT NULL
  • P_NAME — VARCHAR2(100)
  • P_STANDARD — VARCHAR2(200)
  • P_COUNT — NUMBER
  • P_UNIT_PRICE — NUMBER
  • P_SUPPLY_PRICE — NUMBER
  • P_VAT — NUMBER
  • P_NOTE — VARCHAR2(1000)

PROJECT

  • PROJECT_NO — NUMBER — Primary key — NOT NULL
  • PROJECT_NAME — VARCHAR2(100)
  • PROJECT_CONTENTS — LONG
  • PROJECT_START — DATE
  • PROJECT_END — DATE
  • PROJECT_COLOR — VARCHAR2(30)
  • PROJECT_UMONEY — NUMBER

SALE

  • SALE_CODE — VARCHAR(255) — Primary key — NOT NULL
  • P_NO — NUMBER — NOT NULL
  • C_NO — NUMBER — NOT NULL
  • WAREHOUSE_NO — NUMBER — NOT NULL
  • EMPLOYEE_NO — NUMBER — NOT NULL
  • PROJECT_NO — NUMBER — NOT NULL
  • SALE_SUM — NUMBER
  • SALE_DATE — DATE
  • DEPOSIT_DL — DATE

STATEMENT

  • S_NO — NUMBER — Primary key — NOT NULL
  • C_NO — NUMBER — NOT NULL
  • P_NO — NUMBER — NOT NULL
  • PROJECT_NO — NUMBER — NOT NULL
  • MANAGER — NUMBER — NOT NULL
  • O_NO — NUMBER — NOT NULL
  • S_TOTAL — NUMBER
  • S_VALIDITY — DATE
  • Field — VARCHAR(255)
  • TEAM_CODE — VARCHAR2(10) — NOT NULL

TEAM

  • TEAM_CODE — VARCHAR2(10) — Primary key — NOT NULL
  • TEAM_NAME — VARCHAR2(20)
  • TEAMREADER_NO — NUMBER — NOT NULL
  • DEPART_CODE — VARCHAR2(10) — NOT NULL

Untitled

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • E_NO — NUMBER — NOT NULL

Untitled2

  • Key — VARCHAR(255) — Foreign key → Untitled.Key — NOT NULL
  • P_NO — NUMBER — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)

WAREHOUSE

  • WAREHOUSE_NO — NUMBER — Primary key — NOT NULL
  • WAREHOUSE_NAME — VARCHAR2(50)
  • WAREHOUSE_ADDR — VARCHAR2(200)
  • Field — VARCHAR(255)