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_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)