1zari
Tables (10)
bookmark (Untitled6)
- bookmark_id (Key) — UUID — Primary key — NOT NULL
- job_posting_id (Key3) — UUID — Foreign key → job_posting.job_posting_id — NOT NULL
- user_info_id (Key2) — UUID — Foreign key → user_info.user_id — NOT NULL
- common_user_id (Key22) — UUID — Foreign key → user_info.common_user_id — NOT NULL
- company_info_id (Key23) — UUID — Foreign key → job_posting.company_id — NOT NULL
career_info (Untitled7)
- career_info_id (Key) — UUID — Primary key — NOT NULL
- resume_id (Key2) — UUID — Foreign key → resume.resume_id — NOT NULL
- company_name (Field) — VARCHAR(20)
- position (Field2) — VARCHAR(20)
- employment_period_start (Field3) — DATE
- employment_period_end (Field6) — DATE
- created_at (Field4) — TIMESTAMP
- updated_at (Field5) — TIMESTAMP
certification (Untitled8)
- certification_id (Key) — UUID — Primary key — NOT NULL
- resume_id (Key2) — UUID — Foreign key → resume.resume_id — NOT NULL
- certification_name (Field) — VACHAR(20)
- issuing_organization (Field2) — VARCHAR(20)
- date_acquired (Field3) — TIMESTAMP
- created_at (Field4) — TIMESTAMP
- updated_at (Field5) — TIMESTAMP
common_user (Untitled)
- common_user_id (Key) — UUID — Primary key — NOT NULL
- email (Field) — VARCHAR(20)
- password (Field2) — VARCHAR()
- is_staff (Field6) — BOOL
- is_active (Field7) — BOOL
- last_login (Field5) — TIMESTAMP
- created_at (Field3) — TIMESTAMP
- updated_at (Field4) — TIMESTAMP
company_info (Untitled4)
- company_id (Key) — UUID — Primary key — NOT NULL
- common_user_id (Key2) — UUID — Foreign key → common_user.common_user_id — NOT NULL
- company_name (Field14) — VARCHAR(50)
- establishment (Field15) — TIMESTAMP
- company_address (Field16) — VARCHAR(50)
- business_registration_number (Field) — VARCHAR(20)
- company_introduction (Field2) — TEXTFIELD
- certificate_image (Field3) — URLFIELD
- company_logo (Field6) — URLFIELD
- ceo_name (Field7) — VARCHAR(20)
- manager_name (Field4) — VARCHAR(30)
- manager_phone_number (Field8) — VARCHAR(30)
- manager_email (Field5) — VARCHAR(50)
- create_at (Field12) — TIMESTAMP
- update_at (Field13) — TIMESTAMP
district (Untitled9)
- city_no (Field) — VARCHAR(20)
- city_name (Field2) — VARCHAR(40)
- district_no (Field3) — VARCHAR(20)
- district_name (Field4) — VARCHAR(40)
- emd_no (Field5) — VARCHAR(20)
- emd_name (Field6) — VARCHAR(40)
- geometry (Field7) — MULTIPOLYGON [SRID=5179]
job_posting (Untitled3)
- job_posting_id (Key) — UUID — Primary key — NOT NULL
- company_id (Key2) — UUID — Foreign key → company_info.company_id — NOT NULL
- job_posting_title (Field) — VARCHAR(50)
- address (Field16) — VARCHAR(50)
- city (Field17) — VARCHAR(10)
- district (Field18) — VARCHAR(10)
- town (Field19) — VARCHAR(10)
- location (Field20) — POINT[5179]
- work_time_start (Field21) — TIME
- work_time_end (Field22) — TIME
- posting_type (Field23) — VARCHAR(10)
- employment_type (Field24) — VARCHAR(10)
- work_experience (Field25) — VARCHAR(10)
- work_place (Field2) — JSON
- job_keyword_main (Field26) — VARCHAR(20)
- job_keyword_sub (Field27) — ARRAYFIELD
- number_of_positions (Field7) — INT
- education (Field8) — VARCHAR(20)
- deadline (Field9) — TIMESTAMP
- time_discussion (Field28) — BOOL
- day_discussion (Field29) — BOOL
- work_day (Field3) — ARRAYFIELD
- salary_type (Field30) — VARCHAR(10)
- salary (Field10) — INT
- summary (Field11) — VARCHAR(50)
- content (Field12) — TEXT
- created_at (Field31) — TIMESTAMP
- updated_at (Field4) — TIMESTAMP
resume (Untitled5)
- resume_id (Key) — UUID — Primary key — NOT NULL
- user_id (Key3) — UUID — Foreign key → user_info.user_id — NOT NULL
- job_category (Field) — VARCHAR(20)
- education_level (Field2) — VARCHAR(20)
- education_state (Field3) — VARVHAR(20)
- school_name (Field6) — VARCHAR(20)
- resume_title (Field7) — VARCHAR(20)
- introduce (Field8) — TEXT
- created_at (Field4) — TIMESTAMP
- updated_at (Field5) — TIMESTAMP
submission (Untitled10)
- submission_id (Key) — UUID — Primary key — NOT NULL
- job_posting_id (Key2) — UUID — Foreign key → job_posting.job_posting_id — NOT NULL
- user_id (Key3) — UUID — Foreign key → user_info.user_id — NOT NULL
- snapshot_resume (Field) — JSON
- memo (Field2) — VARCHAR(50)
- is_read (Field3) — BOOL
- created_at (Field4) — TIMESTAMP
- updated_at (Field5) — TIMESTAMP
user_info (Untitled2)
- user_id (Key) — UUID — Primary key — NOT NULL
- common_user_id (Key2) — UUID — Foreign key → common_user.common_user_id — NOT NULL
- name (Field) — VARCHAR(30)
- phone_number (Field2) — VARCHAR(20)
- gender (Field7) — VARCHAR(10)
- birthday (Field3) — TIMESTAMP
- interest (Field4) — ARRAYFIELD
- purpose_subscription (Field5) — ARRAYFIELD
- route (Field6) — ARRAYFIELD
- created_at (Field8) — TIMESTAMP
- updated_at (Field9) — TIMESTAMP