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