szsAssignment

Tables (3)

MEMBER (회원)

  • id (회원 ID) — BIGINT — Primary key — NOT NULL
  • user_id (로그인 ID) — VARCHAR(20)
  • password (비밀번호) — VARCHAR(60)
  • name (이름) — VARCHAR(20)
  • reg_no (주민등록번호) — VARCHAR(30)
  • role_type (권한) — VARCHAR(20)
  • created_date (생성일자) — TIMESTAMP
  • last_modified_date (마지막 수정일자) — TIMESTAMP

REFRESH_TOKEN (리프레시 토큰)

  • id (리프레시 토큰 ID) — BIGINT — Primary key — NOT NULL
  • member_id (회원 ID) — BIGINT — Foreign key → MEMBER.id — NOT NULL
  • refresh_token (리프레시 토큰) — VARCHAR(255)
  • created_date (생성일자) — TIMESTAMP
  • last_modified_date (마지막 수정일자) — TIMESTAMP

TaxInfo (세금 정보)

  • id (세금정보 ID) — BIGINT — Primary key — NOT NULL
  • member_id (회원 ID) — BIGINT — Foreign key → MEMBER.id — NOT NULL
  • calculated_amount (산출 세액) — BIGINT
  • total_salary (총 급여) — BIGINT
  • retirement_pension (퇴직연금 납입금액) — BIGINT
  • Insurance (보험료 공제금액) — BIGINT
  • education (교육비 공제금액) — BIGINT
  • donation (기부금 공제금액) — BIGINT
  • medical (의료비 공제금액) — BIGINT
  • created_date (생성일자) — TIMESTAMP
  • last_modified_date (마지막 수정일자) — TIMESTAMP