wishD-proj

Tables (17)

chat_message

  • chat_room_id — BIGINT — Primary key — NOT NULL
  • pboard_id — BIGINT — Foreign key → project_board.pboard_id — NOT NULL
  • f_request_id — BIGINT — Foreign key → request_freelancer.f_request_id — NOT NULL
  • user_no — BIGINT — NOT NULL
  • chat_content — TEXT — NOT NULL
  • chat_date — TIMESTAMP
  • chat_isMatching — BOOLEAN — NOT NULL

community_QnA

  • qcommunity_num — BIGINT — Primary key — NOT NULL
  • user_no — BIGINT — Foreign key → user_info.user_no — NOT NULL
  • user_name — VARCHAR(25) — NOT NULL
  • qcommunity_title — VARCHAR(25) — NOT NULL
  • qcommunity_content — TEXT — NOT NULL
  • qcommunity_answer — VARCHAR(255)
  • qcommunity_date — TIMESTAMP — NOT NULL
  • user_email — VARCHAR(100) — NOT NULL

community_notice

  • ncommunity_num — BIGINT — Primary key — NOT NULL
  • admin_id — BIGINT — Foreign key → user_info.user_no — NOT NULL
  • ncommunity_title — VARCHAR(50) — NOT NULL
  • ncommunity_content — TEXT — NOT NULL
  • ncommunity_date — TIMESTAMP — NOT NULL
  • ncommunity_update — TIMESTAMP — NOT NULL

freelancer

  • freelancer_id — BIGINT — Primary key — NOT NULL
  • user_no — BIGINT — Foreign key → user_info.user_no — NOT NULL
  • freelancer_salary — INT — NOT NULL
  • freelancer_startdate — TIMESTAMP — NOT NULL
  • freelancer_exp — BOOLEAN — NOT NULL
  • dev_exp — INT — NOT NULL
  • freelancer_introduction — TEXT
  • freelancer_link — VARCHAR(255)
  • freelancer_state — VARCHAR(25) — NOT NULL
  • freelancer_date — TIMESTAMP — NOT NULL
  • freelancer_update — TIMESTAMP — NOT NULL
  • job_id — INT — Foreign key → jobs.job_id — NOT NULL
  • freelancer_isMatching — BOOLEAN — NOT NULL

freelancer_file

  • request_num — BIGINT — Foreign key → request_client.request_num — NOT NULL
  • freelancer_id — BIGINT — Foreign key → request_client.freelancer_id — NOT NULL
  • f_file_name — VARCHAR(255) — NOT NULL
  • f_file_path — VARCHAR(255) — NOT NULL
  • f_file_uploadDate — TIMESTAMP — NOT NULL
  • fileOriginName — VARCHAR(255) — NOT NULL

freelancer_skill

  • freelancer_id — BIGINT — Foreign key → freelancer.freelancer_id — NOT NULL
  • skill_id — INT — Foreign key → skills.skill_id — NOT NULL

jobs

  • job_id — INT — Primary key — NOT NULL
  • job_name — VARCHAR(255) — NOT NULL

project_board

  • pboard_id — BIGINT — Primary key — NOT NULL
  • user_no — MEDIUMTEXT — Foreign key → user_info.user_no — NOT NULL
  • pboard_title — VARCHAR(255) — NOT NULL
  • pboard_content — TEXT — NOT NULL
  • pboard_money — BIGINT — NOT NULL
  • pboard_startDate — TIMESTAMP — NOT NULL
  • pboard_rangemonth — INT — NOT NULL
  • pboard_state — VARCHAR(50) — NOT NULL
  • pboard_history — INT — NOT NULL
  • pboard_date — TIMESTAMP — NOT NULL
  • pboard_ — update` — NOT NULL
  • pboard_isMatching — BOOLEAN — NOT NULL
  • pboard_manager_phone — VARCHAR(50) — NOT NULL
  • pboard_company_name — VARCHAR(255) — NOT NULL
  • job_id — INT — Foreign key → jobs.job_id — NOT NULL

project_request_files

  • f_request_id — BIGINT — Foreign key → request_freelancer.f_request_id — NOT NULL
  • pboard_id — BIGINT — Foreign key → request_freelancer.pboard_id — NOT NULL
  • p_file_name — VARCHAR(255) — NOT NULL
  • p_file_path — VARCHAR(255) — NOT NULL
  • p_file_uploadDate — TIMESTAMP — NOT NULL
  • fileOriginName — VARCHAR(255) — NOT NULL

project_skill

  • pboard_id — BIGINT — Foreign key → project_board.pboard_id — NOT NULL
  • skill_id — INT — Foreign key → skills.skill_id — NOT NULL

request_client

  • request_num — BIGINT — Primary key — NOT NULL
  • freelancer_id — BIGINT — Foreign key → freelancer.freelancer_id — NOT NULL
  • user_no — BIGINT — Foreign key → user_info.user_no — NOT NULL
  • cl_subject — VARCHAR(50) — NOT NULL
  • cl_date — INT — NOT NULL
  • cl_startdate — TIMESTAMP — NOT NULL
  • cl_content — TEXT — NOT NULL
  • cl_name — VARCHAR(20) — NOT NULL
  • cl_email — VARCHAR(255) — NOT NULL
  • cl_request_date — TIMESTAMP — NOT NULL
  • cl_request_isAgree — BOOLEAN — NOT NULL
  • cl_money — INT — NOT NULL

request_freelancer

  • f_request_id — BIGINT — Primary key — NOT NULL
  • pboard_id — BIGINT — Foreign key → project_board.pboard_id — NOT NULL
  • user_no — BIGINT — Foreign key → user_info.user_no — NOT NULL
  • f_request_title — VARCHAR(255) — NOT NULL
  • f_request_history — INT — NOT NULL
  • f_request_exp — BOOLEAN — NOT NULL
  • f_request_money — BIGINT — NOT NULL
  • f_reqeust_startDate — TIMESTAMP — NOT NULL
  • f_request_date — TIMESTAMP
  • job_id — INT — Foreign key → jobs.job_id — NOT NULL
  • f_request_isAgree — BOOLEAN — NOT NULL

request_skill

  • f_request_id — BIGINT — Foreign key → request_freelancer.f_request_id — NOT NULL
  • skill_id — INT — Foreign key → skills.skill_id — NOT NULL

simple_user

  • user_no — BIGINT — Foreign key → user_info.user_no — NOT NULL
  • access_Token — VARCHAR(255) — NOT NULL

skills

  • skill_id — INT — Primary key — NOT NULL
  • skill_name — VARCHAR(50) — NOT NULL

user

  • user_no — BIGINT — Foreign key → user_info.user_no — NOT NULL
  • user_id — VARCHAR(25) — NOT NULL
  • user_pass — VARCHAR(25) — NOT NULL
  • user_phone — VARCHAR(20) — NOT NULL

user_info

  • user_no — BIGINT — Primary key — NOT NULL
  • user_name — VARCHAR(25) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • join_date — TIMESTAMP — NOT NULL
  • user_yn — BOOLEAN — NOT NULL
  • user_type — VARCHAR(25)
  • user_role — VARCHAR(25) — NOT NULL