Youthy

테이블 (8)

멤버 카테고리 (member_category)

  • member_category_id — BIGINT — 기본 키 — NOT NULL
  • id — BIGINT — 외래 키 → 회원.id — NOT NULL
  • category_id — BIGINT — 외래 키 → 카테고리.category_id — NOT NULL

정책 (youth_policy)

  • policy_no — VARCHAR(50) — 기본 키 — NOT NULL
  • policy_category_id — BIGINT — 외래 키 → 정책 카테고리.policy_category_id — NOT NULL
  • 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 — BIGINT
  • scrap_count — BIGINT

정책 카테고리 (policy_category)

  • policy_category_id — BIGINT — 기본 키 — NOT NULL
  • category_id — BIGINT — 외래 키 → 카테고리.category_id — NOT NULL

정책_지역 (policy_residence)

  • id — BIGINT — 기본 키 — NOT NULL
  • policy_no — VARCHAR(50) — 외래 키 → 정책.policy_no — NOT NULL
  • zip_code — VARCHAR(10)

카테고리 (category)

  • category_id — BIGINT — 기본 키 — NOT NULL
  • category_name — VARCHAR(255)

회원 (member)

  • id — BIGINT — 기본 키 — NOT NULL
  • kakao_id — BIGINT — NOT NULL
  • email — VARCHAR(255)
  • username — VARCHAR(100)
  • token_version — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

회원 거주지 (member_address)

  • address_id — BIGINT — 기본 키 — NOT NULL
  • id — BIGINT — 외래 키 → 회원.id — NOT NULL
  • address_name — VARCHAAR(255)
  • address_detail — VARCHAAR(255)
  • address_apply — INT

회원 정책 스크랩 (member_scrap_policy)

  • scrap_id — BIGINT — 기본 키 — NOT NULL
  • id — BIGINT — 외래 키 → 회원.id — NOT NULL
  • policy_no — VARCHAR(50) — 외래 키 → 정책.policy_no — NOT NULL
  • created_at — TIMESTAMP