yeoun

Tables (6)

NOTICE

  • DELETEYN — VARCHAR2(1 CHAR)
  • NOTICEYN — VARCHAR2(1 CHAR)
  • CREATED_USER — VARCHAR2(7 CHAR)
  • UPDATED_USER — VARCHAR2(7 CHAR)
  • CREATED_DATE — TIMESTAMP
  • NOTICE_ID — NUMBER(19,0)
  • UPDATED_DATE — TIMESTAMP
  • NOTICE_CONTENT — VARCHAR2(255 CHAR)
  • NOTICE_TITLE — VARCHAR2(255 CHAR)

SCHEDULE

  • ALLDAYYN — VARCHAR2(1 CHAR)
  • CREATED_USER — VARCHAR2(7 CHAR)
  • CREATED_DATE — TIMESTAMP
  • SCHEDULE_FINISH — TIMESTAMP
  • SCHEDULE_ID — NUMBER(19,0)
  • SCHEDULE_START — TIMESTAMP
  • UPDATED_DATE — TIMESTAMP
  • SCHEDULE_CONTENT — VARCHAR2(255 CHAR)
  • SCHEDULE_TITLE — VARCHAR2(255 CHAR)
  • SCHEDULE_TYPE — VARCHAR2(255 CHAR)

SCHEDULE_SHARER

  • SCHEDULE_ID — NUMBER(19,0)
  • SHARED_EMP_ID — VARCHAR2(255 CHAR)

notice

  • notice_id — NUMBER(19) — Primary key — NOT NULL
  • deleteyn — VARCHAR2(1 CHAR) — NOT NULL
  • noticeyn — VARCHAR2(1 CHAR) — NOT NULL
  • created_user — VARCHAR2(7 CHAR) — NOT NULL
  • updated_user — VARCHAR2(7 CHAR)
  • created_date — TIMESTAMP
  • updated_date — TIMESTAMP
  • notice_content — VARCHAR2(255 CHAR) — NOT NULL
  • notice_title — VARCHAR2(255 CHAR) — NOT NULL

schedule

  • schedule_id — NUMBER(19) — Primary key — NOT NULL
  • alldayyn — VARCHAR2(1 CHAR) — NOT NULL
  • created_user — VARCHAR2(7 CHAR) — NOT NULL
  • created_date — TIMESTAMP
  • schedule_finish — TIMESTAMP — NOT NULL
  • schedule_start — TIMESTAMP — NOT NULL
  • updated_date — TIMESTAMP
  • schedule_content — VARCHAR2(255 CHAR) — NOT NULL
  • schedule_title — VARCHAR2(255 CHAR) — NOT NULL
  • schedule_type — VARCHAR2(255 CHAR) — NOT NULL

schedule_sharer

  • shared_emp_id — VARCHAR2(255 CHAR) — Primary key — NOT NULL
  • schedule_id — NUMBER(19) — Foreign key → schedule.schedule_id — NOT NULL