high-level-design
Tables (19)
alarm (Untitled12)
- id (Key) — int — Primary key — NOT NULL
- comp_info_id (Key2) — int — Foreign key → comp_info.id — NOT NULL
- alarm_text (Field) — text
- third_party_app (Field2) — varchar
applicant_tracking (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- job_posting_id (Key2) — int — Foreign key → job_posting.id — NOT NULL
- resume_tracking_id (Key3) — int — Foreign key → resume_tracking.id — NOT NULL
- status (Field) — varchar
- applied_date (Field2) — date
application_info (Untitled6)
- id (Key) — int — Primary key — NOT NULL
- applicant_name, email (Key2) — Primary key — NOT NULL
- applicant_name (Field) — varchar
- email (Field2) — varchar
- phone (Field3) — varchar
- address (Field4) — varchar
- birth_date (Field5) — date
applied_companies (Untitled9)
- id (Key) — int — Primary key — NOT NULL
- comp_info_id (Key2) — int — Foreign key → comp_info.id — NOT NULL
- applicant_info_id (Key3) — int — Foreign key → application_info.id — NOT NULL
career (Untitled7)
- id (Key) — int — Primary key — NOT NULL
- applicant_id (Key2) — int — Foreign key → application_info.id — NOT NULL
- company_name (Field) — varchar
- position (Field2) — varchar
- start_date (Field3) — date
- end_date (Field4) — date
- work_description (Field5) — text
com_user_authority (Untitled14)
- id (Key) — int — Primary key — NOT NULL
- hr_managers_id (Key2) — int — Foreign key → hr_managers.id — NOT NULL
- authority_name (Field) — varchar
comp_info (Untitled)
- id (Key) — int — Primary key — NOT NULL
- email (Key2) — Primary key — NOT NULL
- com_user_id (bigint) — varchar
- business_number (Field) — varchar
- address (Field2) — varchar
- email (Field3) — varchar
comp_prof (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- comp_info_id (Key3) — int — Foreign key → comp_info.id — NOT NULL
- logo (Field) — varchar
- employee_count (Field2) — int
- revenue (Field3) — bigint
- business_item (Field4) — varchar
- ceo_name (Field5) — varchar
- address (Field6) — varchar
education (Untitled8)
- id (Key) — int — Primary key — NOT NULL
- applicant_id (Key2) — int — Foreign key → application_info.id — NOT NULL
- school_name (Field) — varchar
- major (Field2) — varchar
- entrance_year (Field3) — year
- graduation_year (Field4) — year
- degree (Field5) — varchar
hr_managers (Untitled10)
- id (Key) — int — Primary key — NOT NULL
- comp_info_id (Key2) — int — Foreign key → comp_info.id — NOT NULL
- position (Field) — varchar
job_posting (Untitled3)
- id (Key) — int — Primary key — NOT NULL
- comp_info_id (Key22) — int — Foreign key → comp_info.email — NOT NULL
- job_title (Field) — varchar
- description (Field2) — text
- post_date (Field3) — date
job_posting_skill (Untitled4)
- id (Key) — int — Primary key — NOT NULL
- job_posting_id (Key2) — int — Foreign key → job_posting.id — NOT NULL
- skill_name (Field) — varchar
manage_users (Untitled17)
- id (Key3) — int — Primary key — NOT NULL
- applicant_info_id (Key) — int — Foreign key → application_info.id — NOT NULL
- status (Field) — varchar
menu (Untitled15)
- id (Key) — int — Primary key — NOT NULL
- com_user_id (Key2) — int — Foreign key → com_user_authority.id — NOT NULL
- url (Field) — varchar
- menu_name (Field2) — varchar
message (Untitled13)
- id (Key) — int — Primary key — NOT NULL
- comp_info_id (Key2) — int — Foreign key → comp_info.id — NOT NULL
- applicant_info_id (Key3) — int — Foreign key → application_info.id — NOT NULL
- receiver (Field) — varchar
payment (Untitled11)
- id (Key) — int — Primary key — NOT NULL
- comp_info_id (Key2) — int — Foreign key → comp_info.id — NOT NULL
- payment_method (Field) — varchar
- card_info (Field2) — varchar
- paid_at (Field3) — date
payment/sales (Untitled16)
- id (Key) — int — Primary key — NOT NULL
- payment_id (Key2) — int — Foreign key → payment.id — NOT NULL
- net_sales (Field) — decimal
- fees (Field2) — decimal
resume_tracking (CopyOfUntitled8)
- id (Key) — int — Primary key — NOT NULL
- applicant_id (Key2) — int — Foreign key → application_info.id — NOT NULL
- resume_text (Field) — text
- submission_date (Field5) — date
skill (CopyOfUntitled7)
- id (Key) — int — Primary key — NOT NULL
- applicant_id (Key2) — int — Foreign key → application_info.id — NOT NULL
- career_id (Key3) — int — Foreign key → career.id — NOT NULL
- skill_name (Field) — varchar
- proficiency (Field2) — varchar