유씨

테이블 (10)

category

  • category_id — BIGINT
  • category_name — VARCHAR(255) — NOT NULL

member

  • id — BIGINT
  • kakao_id — BIGINT — NOT NULL
  • email — VARCHAR(255)
  • username — VARCHAR(100)

member_address

  • address_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • address_name — VARCHAR(255)
  • address_detail — VARCHAR(255)
  • address_apply — INT

member_category

  • member_category_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • category_id — BIGINT — NOT NULL
  • created_at — DATETIME(6)

member_scrap_policy

  • scrap_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • policy_no — VARCHAR(50) — NOT NULL
  • created_at — DATETIME(6)

policy_category

  • policy_no — VARCHAR(50) — 기본 키 — NOT NULL
  • category_id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME(6)

policy_residence

  • id — BIGINT
  • policy_no — VARCHAR(50) — NOT NULL
  • zip_code — VARCHAR(10)

refresh_token

  • id — BIGINT
  • member_id — BIGINT
  • jti — VARCHAR(255) — NOT NULL
  • token_hash — VARCHAR(128) — NOT NULL
  • user_agent — VARCHAR(500)
  • ip — VARCHAR(100)
  • expires_at — DATETIME(6)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

search_term_hourly

  • id — BIGINT
  • hour_start — DATETIME(0) — NOT NULL
  • category_id — BIGINT
  • term — VARCHAR(255) — NOT NULL
  • cnt — INT — NOT NULL

youth_policy

  • policy_no — VARCHAR(50)
  • policy_name — VARCHAR(255) — NOT NULL
  • policy_field — VARCHAR(255)
  • support_content — TEXT
  • operation_period — VARCHAR(500)
  • application_period — VARCHAR(500)
  • support_scale — VARCHAR(255)
  • min_age — INT
  • max_age — INT
  • income_condition — TEXT
  • education_requirement — VARCHAR(255)
  • major_requirement — VARCHAR(255)
  • employment_status — VARCHAR(255)
  • specialized_field — VARCHAR(255)
  • additional_info — TEXT
  • participation_restriction — TEXT
  • application_process — TEXT
  • evaluation_announcement — TEXT
  • application_site — VARCHAR(1000)
  • required_documents — TEXT
  • application_start_date — DATE
  • application_end_date — DATE
  • view_count — INT — NOT NULL