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