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)