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