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