react_freelancer

Tables (11)

t_project

  • seq (Field) — bigint — Primary key
  • user_seq (Field34) — bigint — Foreign key → t_user.seq
  • title (Field2)
  • type_cd (Field3)
  • status_cd (Field4)
  • category_cd (Field5)
  • branch_cd (Field6)
  • branch_desc (Field7)
  • language_cd (Field8)
  • language_desc (Field9)
  • server_cd (Field10)
  • server_desc (Field11)
  • db_cd (Field12)
  • db_desc (Field13)
  • plan_cd (Field14)
  • plan_status_cd (Field15)
  • plan_status_desc (Field16)
  • file_group_seq (Field17)
  • desc (Field18)
  • content (Field19)
  • memo (Field20)
  • budget (Field21)
  • total_budget (Field22)
  • estimated_start_date (Field23)
  • estimated_end_date (Field24)
  • estimated_duration (Field25)
  • client_addr (Field26)
  • meeting_type_cd (Field33)
  • recruit_end_cd (Field35)
  • staff_cd (Field36)
  • staff_type_cd (Field37)
  • contract_date (Field38)
  • start_date (Field39)
  • end_date (Field40)
  • admin_memo (Field41)
  • created_date (Field27)
  • created_ip (Field28)
  • created_by (Field29)
  • modified_date (Field30)
  • modified_ip (Field31)
  • modified_by (Field32)

t_project_history

  • seq (Field)
  • project_seq (Field10) — bigint — Foreign key → t_project.seq
  • title (Field2)
  • file_group_seq (Field3)
  • content (Field4)
  • created_date (Field5)
  • created_ip (Field6)
  • created_by (Field7)
  • modified_date (Field8)
  • modified_ip (Field9)
  • modified_by (Field11)
  • is_deleted (Field12)

t_project_payment

  • seq (Field2)
  • project_seq (Field18) — bigint — Foreign key → t_project.seq
  • transaction_type_cd (Field)
  • amount (Field3)
  • pay_date (Field4)
  • actual_pay_date (Field5)
  • paid_date (Field6)
  • actual_paid_date (Field11)

t_project_schedule

  • seq (Field2)
  • project_seq (Field18) — bigint — Foreign key → t_project.seq
  • status_cd (Field)
  • project_start_date (Field3)
  • project_end_date (Field4)
  • start_date (Field5)
  • end_date (Field6)
  • inspection_end_date (Field11)
  • actual_end_date (Field7)
  • memo (Field8)

t_project_user

  • project_seq (Field18) — bigint — Foreign key → t_project.seq
  • user_seq (Field2)
  • username (Field3)
  • req_type_cd (Field4)
  • approved_yn (Field5)
  • approved_date (Field6)
  • created_date (Field11)

t_user (Untitled)

  • seq (Field) — bigint — Primary key
  • username (Field2)
  • user_type (Field3)
  • password (Field4)
  • fullname (Field5)
  • email (Field6)
  • phone (Field7)
  • mobile (Field8)
  • last_login_date (Field9)
  • file_group_seq (Field10)
  • temp_pwd (Field11)
  • temp_pwd_cre_dt (Field12)
  • temp_pwd_end_dt (Field13)
  • use_yn (Field14)
  • gender (Field15)
  • birthday (Field16)
  • introduction (Field17)
  • zip (Field18)
  • addr (Field19)
  • addr_etc (Field20)
  • company_name (Field21)
  • ceo_name (Field22)
  • company_req_num (Field23)
  • company_file_group_seq (Field24)
  • invoice_email (Field25)
  • admin_memo (Field26)
  • created_date (Field27)
  • created_ip (Field28)
  • created_by (Field29)
  • modified_date (Field30)
  • modified_ip (Field31)
  • modified_by (Field32)
  • Field33

t_user_career (Untitled4)

  • seq (Field)
  • user_seq (Field16) — bigint — Foreign key → t_user.seq
  • company_name (Field2)
  • department (Field3)
  • position (Field4)
  • start_date (Field5)
  • end_date (Field6)
  • desc (Field7)
  • created_date (Field8)
  • created_ip (Field9)
  • created_by (Field10)
  • modified_date (Field11)
  • modified_ip (Field12)
  • modified_by (Field13)
  • is_deleted (Field14)

t_user_certificate (Untitled6)

  • seq (Field)
  • user_seq (Field20) — bigint — Foreign key → t_user.seq
  • serial_num (Field2)
  • cert_name (Field3)
  • desc (Field4)
  • issue_date (Field5)
  • created_date (Field11)
  • created_ip (Field12)
  • created_by (Field13)
  • modified_date (Field14)
  • modified_ip (Field15)
  • modified_by (Field16)
  • is_deleted (Field19)

t_user_education (Untitled5)

  • seq (Field)
  • user_seq (Field20) — bigint — Foreign key → t_user.seq
  • school_cd (Field2)
  • status_cd (Field3)
  • school_name (Field4)
  • profession (Field5)
  • country (Field6)
  • city (Field7)
  • start_date (Field8)
  • end_date (Field9)
  • gpa (Field10)
  • created_date (Field11)
  • created_ip (Field12)
  • created_by (Field13)
  • modified_date (Field14)
  • modified_ip (Field15)
  • modified_by (Field16)
  • is_deleted (Field17)

t_user_portfolio (Untitled2)

  • seq (Field)
  • user_seq (Field2) — bigint — Foreign key → t_user.seq
  • title (Field3)
  • category_cd (Field4)
  • type_cd (Field5)
  • site_url (Field6)
  • desc (Field7)
  • memo (Field8)
  • amount (Field9)
  • start_date (Field10)
  • end_date (Field11)
  • participation (Field12)
  • file_group_seq (Field13)
  • rep_yn (Field14)
  • admin_memo (Field15)
  • created_date (Field16)
  • created_by (Field17)
  • created_ip (Field18)
  • modified_date (Field19)
  • modified_by (Field20)
  • modified_ip (Field21)
  • is_deleted (Field22)

t_user_skill (Untitled3)

  • seq (Field)
  • user_seq (Field10) — bigint — Foreign key → t_user.seq
  • type_cd (Field2)
  • level_cd (Field3)
  • experience_cd (Field4)
  • created_date (Field5)
  • created_ip (Field6)
  • created_by (Field7)
  • modified_date (Field8)
  • modified_ip (Field9)
  • modified_by (Field11)
  • is_deleted (Field12)