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