-- ============================================================
-- 就业一湛通服务平台 - 就业登记模块 视图SQL
-- 视图: V_EMPLOYMENT_REGISTRATION_LIST
-- 说明: 关联就业登记主表和个人信息表，用于列表页查询
-- ============================================================

CREATE VIEW V_EMPLOYMENT_REGISTRATION_LIST AS
SELECT
    ER.ID,
    ER.PERSONAL_ID,
    ER.PROVINCE_RECORD_ID,
    ER.REGISTRATION_STATUS,
    ER.LAST_NOTICE_TIME,
    PI.FULL_NAME,
    PI.GENDER,
    PI.EDUCATION,
    PI.HOUSEHOLD_LOCATION,
    PI.CONTACT_PHONE
FROM EMPLOYMENT_REGISTRATION ER
LEFT JOIN PERSONAL_INFO PI ON ER.PERSONAL_ID = PI.ID;