3o3
Tables (6)
INCOME_DEDUCTION (소득 공제)
- seq (소득공제 비식별 ID) — bigint — Primary key — NOT NULL
- scrap_seq (스크래핑 비식별 ID) — bigint — Foreign key → SCRAP.seq — NOT NULL
- income_deduction_type (소득 공제 타입) — enum
- year_month (년 월) — varchar
- deduction_amount (공제액) — varchar(255)
- created_at (생성일시) — timestamp
- modified_at (수정일시) — timestamp
LOGIN_HISTORY (로그인 이력)
- seq (로그인 이력 비식별 ID) — bigint — Primary key — NOT NULL
- user_seq (회원 비식별 ID (Join)) — bigint — Foreign key → USERS.seq — NOT NULL
- created_at (생성일시) — timestamp
- modified_at (수정일시) — timestamp
SCRAP (스크래핑 Json 응답값)
- seq (스크래핑 비식별 ID) — bigint — Primary key — NOT NULL
- user_seq (회원 비식별 ID (Join)) — bigint — Foreign key → USERS.seq — NOT NULL
- scrap_json_string (스크래핑 json 데이터) — text
- created_at (생성일시) — timestamp
- modified_at (수정일시) — timestamp
TAX_DEDUCTION (세액공제)
- seq (세액공제 비식별 ID) — bigint — Primary key — NOT NULL
- scrap_seq (스크래핑 비식별 ID) — bigint — Foreign key → SCRAP.seq — NOT NULL
- years (년) — integer
- tax_deduction_amount (세액공제액) — varchar(255)
- created_at (생성일시) — timestamp
- modified_at (수정일시) — timestamp
TOTAL_AMOUNT_INCOME (종합소득금액)
- seq (종합소득금액 비식별 ID) — bigint — Primary key — NOT NULL
- scrap_seq (스크래핑 비식별 ID) — bigint — Foreign key → SCRAP.seq — NOT NULL
- years (년) — integer
- total_amount_income (종합소득금액) — varchar(255)
- created_at (생성일시) — timestamp
- modified_at (수정일시) — timestamp
USERS (회원)
- seq (회원 비식별 ID) — bigint — Primary key — NOT NULL
- user_id (회원 ID) — varchar(255)
- name (회원 이름) — varchar(255)
- password (비밀번호) — varchar(255)
- reg_no (주민등록번호) — varchar(255)
- iv (주민등록번호를 복호화하는데 필요한 초기화벡터) — varchar(255)
- created_at (생성일시) — timestamp
- modified_at (수정일시) — timestamp