문승환_3차 프로젝트 인트라넷
테이블 (21)
APPROVAL_FILE
- FILE_ID — INT — 기본 키 — NOT NULL
- APPROVAL_ID — INT — NOT NULL
- APPROVAL_FILE_NAME — VARCHAR
- STORAGE — VARCHAR
APPROVAL_FORM
- FORM_ID — INT — 기본 키 — NOT NULL
- SUBJECT — VARCHAR
- CONTENT — VARCHAR
- STATUS — CHAR(1)
- PASSIVE_APPROVAL_OPTION — VARCHAR
- AUTHORITY — VARCHAR
- PRE_APPROVAL — CHAR(1)
- CREATION_DATE — DATE
- MODIFICATION_DATE — DATE
- STORAGE_ID — INT — NOT NULL
APPROVAL_PARTICIPANT
- PARTICIPANT_ID — INT — 기본 키 — NOT NULL
- SEQUENCE — INT — 결재 진행 순서
- TYPE — VARCHAR — 기안자/결재자/합의자
- APPROVAL_STATUS — VARCHAR
- APPROVAL_DATE — DATE
- APPROVAL_ID — INT — NOT NULL
- EMPLOYEE_ID — INT
AUTHORITY
- AUTHORITY_CODE — INT — 기본 키 — NOT NULL
- AUTHORITY_NAME — VARCHAR
CALENDAR
- CALENDAR_ID — INT — 기본 키 — NOT NULL
- CALENDAR_NAME — VARCHAR
- CREATION_DATE — DATE
- DEPARTMENT_CODE — VARCAHR — NOT NULL
CHAT
- ID — INT — 기본 키 — NOT NULL
- MSG — VARCHAR
- ROOM_NUM — INT
- CREATE_AT — DATE
- SENDER — INT
CHAT_ROOM
- ID — INT — 기본 키 — NOT NULL
- EMPLOYEE_ID — INT
- ROOM_NUM — INT
- ROOM_NAME — VARCHAR
DEPARTMENT
- DEPARTMENT_CODE — INT — 기본 키 — NOT NULL
- DEPARTMENT_NAME — VARCHAR
ELECTRONIC_APPROVAL
- APPROVAL_ID — INT — 기본 키 — NOT NULL
- FORM_ID — INT — NOT NULL
- SUBJECT — VARCHAR
- DOC_BODY — VARCHAR — docBody
- REASON — VARCHAR
- REASON_REJECTION — VARCHAR
- URGENCY — VARCHAR
- STATUS — VARCHAR
- DOC_NO — INT — 문서번호
- CREATION_DATE — DATE
- MODIFICATION_DATE — DATE
EMPLOYEE
- EMPLOYEE_ID — INT
- EMPLOYEE_PASSWORD — VARCHAR
- NAME — VARCHAR
- GENDER — VARCHAR
- BIRTH — DATE
- DATE_EMPLOYMENT — DATE
- CONTACT — VARCHAR
- ADDRESS — VARCHAR
- EMAIL_ADDRESS — VARCHAR
- EMPLOYMENT_STATUS — VARCHAR
- AUTHORITY_CODE2 — VARCHAR — NOT NULL
- DEPARTMENT_CODE2 — VARCAHR — NOT NULL
- RANK_CODE2 — VARCHAR — NOT NULL
EMPLOYEE_LEVEL
- LEVEL_CODE — INT — 기본 키 — NOT NULL
- LEVEL_NAME — VARCHAR
EXIT_EMPLOYEE
- EMPLOYEE_ID — INT
- NAME — VARCHAR
- GENDER — VARCHAR
- BIRTH — DATE
- DATE_EMPLOYMENT — DATE
- CONTACT — VARCHAR
- EMAIL_ADDRESS — VARCHAR
- LEVEL_NAME — VARCHAR
- DEPARTMENT_NAME — VARCHAR
- DATE_RETIREMENT — DATE
- REASON_RETIREMENT — VARCHAR
EXIT_FRANCHISEE
- CLOSING_ID — VARCHAR — 기본 키 — NOT NULL — LONG
- CLOSING_NAME — VARCHAR
- OWNER — VARCHAR
- ADDRESS — VARCHAR
- PHONE_NUMBER — VARCHAR
- CONTRACT_DATE — DATE
- EXPIRATION_DATE — DATE
- WARNING_COUNT — INT
- CLOSING_DATE — DATE
- EMPLOYEE_ID — INT
- CLOSING_REASON — VARCHAR
FRANCHISEE
- FRANCHISEE_ID — VARCHAR — 기본 키 — NOT NULL — LONG
- EMPLOYEE_ID — INT — 담당자
- FRANCHISEE_NAME — VARCHAR
- OWNER — VARCHAR
- ADDRESS — VARCHAR
- PHONE_NUMBER — VARCHAR
- CONTRACT_DATE — DATE
- EXPIRATION_DATE — DATE
- WARNING_COUNT — INT
Menu
- MENU_ID — VARCHAR — 기본 키 — NOT NULL — LONG
- MENU_NAME — VARCHAR
- MENU_PRICE — INT — 부가세 포함
- MENU_RECIPE — VARCHAR — 매뉴얼
- MENU_ORIGIN_PRICE — INT
- MENU_END — INT — 단종 : 0, 판매: 1 / default 1
NOTIFICATION
- ID — INT — 기본 키 — NOT NULL
- CONTENT — VARCHAR
- URL — VARCHAR
- IS_READ — BOOLEAN
- IS_VIEW — BOOLEAN
- CREATION_DATE — DATE
- MODIFICATION_DATE — DATE
- EMPLOYEE_ID — INT
ORDER_MANAGEMENT
- ORDER_ID — LONG — 기본 키 — NOT NULL — LONG
- ORDER_QUANTITY — INT
- ORDER_PRICE — INT
- ORDER_DATE — DATE
- FRANCHISEE_ID — VARCHAR — NOT NULL
- MENU_ID — VARCHAR — NOT NULL
SALES_MANAGEMENT
- SALES_ID — INT — 기본 키 — NOT NULL
- MONTHLY_SALES — INT
- YEAR — INT
- MONTH — INT
- FRANCHISEE_ID — VARCHAR — NOT NULL
SCHEDULE
- SCHEDULE_ID — INT — 기본 키 — NOT NULL
- CALENDAR_ID — INT — NOT NULL
- SUBJECT — VARCHAR
- CONTENT — VARCHAR
- START_DATE — DATE
- END_DATE — DATE
- LOCATION — VARCHAR
- START_TIME — TIME
- END_TIME — TIME
STORAGE
- STORAGE_ID — INT — 기본 키 — NOT NULL
- NAME — VARCHAR
- PARENT_STORAGE — INT
- LOCATION — VARCHAR
- DEPT — INT
WARNING
- WARNING_ID — INT — 기본 키 — NOT NULL — LONG
- WARNING_REASON — VARCHAR
- CLOSING_ID — VARCHAR — NOT NULL
- FRANCHISEE_ID — VARCHAR — NOT NULL — SET NULL