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