ㄷㅂㅁㄴㅇ

Tables (25)

alarm

  • alarm_id — bigint
  • alarm_create — datetime(6) — NOT NULL
  • read_or_not — tinyint(1)
  • alarm_content_id — bigint
  • user_id — bigint

alarm_content

  • alarm_content_id — bigint
  • alarm_type — varchar(100)

app_payment

  • app_payment_id — bigint
  • app_payment_date — datetime(6) — NOT NULL
  • berry_bucket — bigint — NOT NULL
  • sell_user_id — bigint — NOT NULL
  • personal_id — bigint

archive

  • arch_id — bigint
  • arch_blog — varchar(100)
  • arch_git — varchar(100)
  • arch_notion — varchar(100)
  • resume_id — bigint

benner

  • benner_id — bigint
  • benner_img — varchar(255) — NOT NULL
  • benner_text — varchar(255) — NOT NULL
  • benner_url — varchar(255) — NOT NULL

board

  • corr_id — bigint
  • corr_content — varchar(255) — NOT NULL
  • corr_create — datetime(6) — NOT NULL
  • corr_modify — datetime(6) — NOT NULL
  • corr_pdf — varchar(100) — NOT NULL
  • corr_point — int — NOT NULL
  • corr_title — varchar(100) — NOT NULL
  • corr_view — int
  • user_id — bigint

career

  • career_id — bigint
  • career_date — varchar(100)
  • career_job — varchar(100)
  • career_name — varchar(100)
  • career_position — varchar(100)
  • resume_id — bigint

certificate

  • cert_id — bigint
  • cert — varchar(100)
  • cert_date — varchar(100)
  • resume_id — bigint

comment

  • comm_id — bigint
  • comm_content — varchar(255)
  • comm_create — datetime(6) — NOT NULL
  • comm_modify — datetime(6) — NOT NULL
  • comm_selection — bit — NOT NULL
  • corr_id — bigint
  • user_id — bigint

company_user

  • company_id — bigint
  • company_addr — varchar(100) — NOT NULL
  • company_ceo — varchar(255) — NOT NULL
  • company_logo — varchar(255) — NOT NULL
  • company_num — varchar(100) — NOT NULL
  • company_year — date — NOT NULL
  • user_id — bigint

curriculum

  • curri_id — bigint
  • curri_company — varchar(100)
  • curri_content — varchar(100)
  • curri_date — varchar(100)
  • resume_id — bigint

education

  • edu_id — bigint
  • credit — varchar(100)
  • edu — varchar(100) — NOT NULL
  • edu_date — varchar(100)
  • resume_id — bigint

etc

  • etc_id — bigint
  • etc_content — varchar(100)
  • etc_date — varchar(100)
  • resume_id — bigint

job

  • job_id — bigint
  • job_name — varchar(100)

job_position

  • user_job_id — bigint
  • job_id — bigint
  • personal_id — bigint

pay_history

  • pay_history_id — bigint
  • berry_bucket — varchar(100) — NOT NULL
  • buyer_id — bigint — NOT NULL
  • pay_history_content — varchar(255) — NOT NULL
  • pay_history_date — datetime(6) — NOT NULL
  • seller_id — bigint
  • personal_id — bigint

payment

  • pay_id — bigint
  • berry_point — bigint — NOT NULL
  • pay_date — datetime(6) — NOT NULL
  • pay_num — bigint — NOT NULL
  • pay_state — varchar(255) — NOT NULL
  • personal_id — bigint

personal_user

  • personal_id — bigint
  • gender — varchar(255)
  • is_company_visible — tinyint(1)
  • is_personal_visible — tinyint(1)
  • personal_career — varchar(100) — NOT NULL
  • user_id — bigint

pick_and_scrap

  • pick_id — bigint
  • pick — tinyint(1)
  • scrap — tinyint(1)
  • company_id — bigint
  • personal_id — bigint

portfolio

  • port_id — bigint
  • port_file — varchar(255)
  • resume_id — bigint

reply

  • comm_id — bigint
  • comm_content — varchar(255)
  • comm_create — datetime(6) — NOT NULL
  • comm_modify — datetime(6) — NOT NULL
  • comm_selection — bit — NOT NULL
  • corr_id — bigint
  • user_id — bigint

resume

  • resume_id — bigint
  • personal_state — varchar(255)
  • phone_num — varchar(100) — NOT NULL
  • resume_create — datetime(6) — NOT NULL
  • resume_date — varchar(100) — NOT NULL
  • resume_name — varchar(100) — NOT NULL
  • resume_photo — varchar(255)
  • resume_update — datetime(6) — NOT NULL
  • personal_id — bigint

tech

  • tech_id — bigint
  • tech_name — varchar(100)
  • tech_url — varchar(100)

tech_stack

  • user_tech_id — bigint
  • personal_id — bigint
  • tech_id — bigint

user

  • user_id — bigint
  • email — varchar(100) — NOT NULL
  • password — varchar(100) — NOT NULL
  • user_create — datetime(6) — NOT NULL
  • user_intro — varchar(255) — NOT NULL
  • user_name — varchar(100) — NOT NULL
  • user_type — varchar(255) — NOT NULL