문승환_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