demo
Tables (4)
attendance_record (출퇴근 근무시간)
- a_ID (근무기록 번호) — BIGINT — Primary key — NOT NULL — PK
- u_ID (유저번호) — BIGINT — NOT NULL
- a_WORK_DATE (근무일) — DATE — NOT NULL
- a_CLOCK_IN_AT (출근시간) — TIMESTAMPTZ — NOT NULL
- a_CLOCK_OUT_AT (퇴근시간) — TIMESTAMPTZ
- a_BREAK_MINUTES (휴게시간) — INTEGER — NOT NULL — DEFAULT(0)
- a_MODIFIED_USER_ID (수정인) — BIGINT
- a_MODIFIED_REASON (수정사유) — TEXT
- a_UPDATE_AT (수정시간) — TIMESTAMPTZ — NOT NULL — DEFAULT(CURRENT_TIMESTAMP)
post (게시판)
- p_ID (게시글번호) — BIGINT — Primary key — NOT NULL — PK
- u_ID (유저번호) — BIGINT — NOT NULL
- p_TITLE (제목) — VARCHAR(200) — NOT NULL
- p_CONTENT (내용) — TEXT — NOT NULL
- p_CREATED_AT (생성일) — TIMESTAMPTZ — NOT NULL — DEFAULT(CURRENT_TIMESTAMP)
- p_UPDATE_AT (수정일) — TIMESTAMPTZ — NOT NULL — DEFAULT(CURRENT_TIMESTAMP)
user (유저)
- u_ID (유저번호) — BIGINT — Primary key — NOT NULL — PK
- u_LOGIN_ID (로그인 ID) — VARCHAR(50) — NOT NULL — UNIQUE
- u_PW (패스워드) — VARCHAR(255) — NOT NULL
- u_NAME (이름) — VARCHAR(100) — NOT NULL
- u_EMAIL (이메일) — VARCHAR(255) — UNIQUE
- u_PHONE (휴대폰 번호) — VARCHAR(30)
- u_ADDRESS (주소) — TEXT
- u_CERTIFICATE (자격증) — TEXT
- u_PROFILE_IMG_PATH (프로필 이미지 경로) — VARCHAR(500)
- u_ROLE (권한레벨) — VARCHAR(20) — NOT NULL — DEFAULT('USER')
- u_STATUS (재직상태) — VARCHAR(20) — NOT NULL — DEFAULT('ACTIVE')
- u_DEPT_NAME (부서명) — VARCHAR(100)
vacation (휴가)
- v_ID (휴가신청번호) — BIGINT — Primary key — NOT NULL — PK
- u_ID (유저번호) — BIGINT — NOT NULL
- v_START_DATE (휴가시작일) — DATE — NOT NULL
- v_END_DATE (휴가종료일) — DATE — NOT NULL
- v_PURPOSE (사유) — TEXT — NOT NULL
- v_STATUS (승인상태) — VARCHAR(20) — NOT NULL — DEFAULT('PENDING')
- v_REVIEW_USER_ID (승인자) — BIGINT
- v_REVIEW_COMMENT (내용) — TEXT
- v_REVIEW_AT (승인일) — TIMESTAMPTZ
- v_CREATED_AT (생성일) — TIMESTAMPTZ — NOT NULL — DEFAULT(CURRENT_TIMESTAMP)