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)