유씨
테이블 (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