Sql parent child table tree query jobs

We are seeking an experienced freelance developer to create a custom dashboard for analyzing real estate data, specifically rental prices and sale prices. The dashboard will need to aggregate and display up-to-date data ...regulations. Required Skills: Proven experience in web development and dashboard creation. Strong programming skills, especially in Python, JavaScript, and the use of web scraping libraries such as BeautifulSoup, Scrapy, or similar. Knowledge of front-end development technologies for creating user interfaces (UI), such as HTML, CSS, and JavaScript frameworks (React, Vue.js, or Angular). Experience with SQL/NoSQL databases for storing and managing collected data. Understanding of data protection issues and the ability to implement secure practices in application de...

...sentence with a set of sentences and subsequently calculate a matching score. The sentences are product titles. We have a MYSQL database with two tables of products, but the titles are not exact. For every entry in Table A, I need to find all the titles from Table B which match the product from Table A within specifed margins (see below). In each table, we also have the brand of the product. The program should only compare titles where they have the same brand. Here's an example: From Table A: Product Title is "Dove Baby Lotion 200ml Fragrance Free" Brand is "Dove" From Table B: Brand "Dove" could have over 100 products, sometimes more. Here's a selection: Dove Anti-Perspirant Deodorant Invisible Soli...

...interactive PDF digital book review journal, accompanied by an editable Canva template. The journal will serve as a comprehensive tool for users to track their reading progress, write detailed book reviews, and organize their literary experiences. The project involves the creation of various pages, including but not limited to: 1. Cover Page: Featuring the title of the journal and relevant branding. 2. Table of Contents: Providing an organized list of sections and pages for easy navigation. 3. Introduction: Offering a brief overview of the purpose and goals of the book review journal. 4. Reading Log: Allowing users to track the books they've read, including titles, authors, dates completed, and ratings. 5. Book Review Template: Providing a structured format for writing deta...

Read before bidding, verification test included. This should be a 30 min project for an expert in google sheets. I have a google sheet with 18 lookup tables in tab "lookup" in other tabs I need to use each of these 18 tables as dropdowns to show the options (with descriptions) but when an item is selected, I only need the number put into the field. Each table is used for 2 cells in 1 row (Now & Goal) See screen shot which shows the data tab (left) and the first 2 lookup tables in the lookup tab (right) No time to waste. To prove you read this posting, put the name of your favorite food in all CAPS as the absolute first word in your bid. Auto bids will be deleted. Your bid is your bid, don't ask budget AFTER we start chatting. I will ban you from all my p...

I need a well-experienced Delphi developer who can create a button within my application. The functionality of this button will be to send what'supp' to a selected supplier from the suppliers table and a memo database field that will be populated from those suppliers. Key Aspects: - The coding should be clean and well-documented so that it can be integrated easily into my larger application. - The feature should allow the user to manually select the supplier from the table. - The information to be sent to the selected supplier will include a PDF file and a text message. Ideal candidate: - Proficiency in Delphi Programming using REST API - A good understanding of database structures - Past experience in creating similar features Please only bid if you can meet th...

...passionate about optimizing website performance and have the expertise to help us tackle this challenge, please reach out with your relevant experience and proposed approach. The issue is persistent and not due to any recent updates or changes, so proven problem-solving skills and a systematic approach to troubleshooting are crucial. The solution should not break if the Theme is upgraded or a child theme may be necessary. We're eager to collaborate with talented professionals who can assist us in achieving our goal of delivering a faster and smoother browsing experience for our users. Please review the job requirements carefully and submit your proposal accordingly. Our discussion will be centered around your proposed solution and its alignment with the requested scope. ...

I'm in the market for an engaging and vibrant brochure to attract a wide range of audience that spans homeowners, business owners, and real-estate agents alike for my interior decoration business. This brochure should not simply be a visual spectacle, but it should also echo my business's track record in delivering top-notch designs. Key Aspects: - A Creative Design: It is crucial that t...Content Creation: Craft compelling copy that tells a story, highlighting our offerings in a manner that's appealing to all our audiences. Skills required: - Graphic Design - Brochure Design - Content Writing - Creative Writing - Experience in creating Advertising collateral - An eye for aesthetics and details Eyes on the prize, everyone. I'm eager to see what exciting concepts you...

I'm in urgent need of a capable developer to create a Table reservation website for restaurants/hotels/cafes, with a focus on efficiency and ease-of-use. Key Project Features: - Integration with for seamless booking experience. - A reservation system that collects user's date, time of visit, number of guests, and contact information. Timing is crucial for this project, I am looking to have the website up and running as soon as possible. Ideal freelancer for this job should have: - Extensive experience in web development and system integration. - Prior exposure to reservation/booking systems. - Ability to work under tight deadlines and deliver quality work. I am looking forward to working with someone experienced in creating powerful and user-friendly reservation sy...

I am looking for an animator who can help me bring a unique and captivating entertainment project to life. This animation will be cartoonish in style and must resonate with children. - Key Requirements - The creation of a cartoon video animation for entertainment purposes - The design has to be colorful, vibrant, and child-friendly - The animation should be creative, engaging and playful enough to captivate a young audience Ideal candidates for this project should have experience in: - Children's animation - Creating high-quality 2D or 3D animations in a cartoonish style - Developing children-focused content Please, include any past work related to children’s entertainment in your proposal. Looking forward to working with you!

I'm seeking an artist proficient in creating realistic or impressionistic landscape paintings with subjects. We are open to different mediums, though most familiar with oil or watercolor. This is to be given as a wedding present. Project Details: - The painting will be a simplified representation of a moment, showing two people under a distinctive pine tree in with mountains in the background and a bluebird in the tree. - We will provide reference photos, but the final work should be a creative and representational piece. - It should be painted using either oil or watercolor, based on your expertise and comfort level. - Must be delivered by early August. Ideal Skills and Experience: - A portfolio featuring previous landscape or subject paintings. - Experienced in w...

I'm seeking an experienced data engineer with a strong background in...strong background in efficient web scraping techniques and a solid understanding of SQL databases. You'll be harvesting data made up of text and images from a various websites. Details of the task include: 1. **Data Scraping**: Extract text and image data effectively from different sources based on the requirements given. 2. **Database Management**: The scraped data must be stored in a SQL-based database. Knowledge in creating, managing, and manipulating SQL databases is essential for this role. Freelancers who have previously worked in similar projects will be preferred. This is a challenging task requiring a keen eye for detail, a deep understanding of data structures and st...

I am currently dealing with some challenges on my WordPress site relating to word press just published. . Most urgently, an issue with the display of a table from my backup, broken links, and an email configuration issue that requires resolving on the back-up. Despite trying to update the PHP, it did not resolve problems with version of 3/6. I'm also stuck using the outdated PHP 7.4. Thus, I need help from an expert with: • PHP updating • Email configuration • Table recovery from backups

...flawlessly copy tables from a Google Sheet document and insert it appropriately into a ChatGPT prompt. -Prefer a chrome extension where a button can be pressed and the current selected table in a google sheet can be formatted and put in the clipboard. Later I can paste into a prompt - Generous attention should be given to formatting details, such as: - Consistency in the use of spaces. - The employment of specific delimiters. - Attractive and clear presentation of table headers. The ultimate goal? To end up with beautifully formatted tables that align perfectly with these guidelines; this table data should be placed into the clipboard for easy pasting into a ChatGPT prompt. To show that you actually read this posting (and not auto bid) put your fav...

Budget: 5$ I'm in immediate need of a professional with skills ...free to browse the internet and find the png logos. All the logos provided should be standard sized, transparent background in png format with one color and one grayscale export. I need the following logos: SAP SAP Business Objects SAP Analytics Cloud Microsoft Microsoft Power BI Microsoft Power Apps Microsoft Azure Microsoft Fabric AWS AWS Redshift Google Google Cloud Platform Google Big Query Tableau Qlik Salesforce Zendesk For your application to be considered, please: - Be experienced in creating and editing logos - Include at least one example of a logo for me to see you can edit this properly. Attention to detail and a quick turnaround time are critical for this project. I look forward to your sp...

I'm seeking a proactive Business Development Executive with strong experience and a knack for market re...market demands and trends. Stay aware of our competitors and their pros and cons. - Client Relationship Management: Maintain relationship with potential clients. Understand their needs and feedback to our product team for continuous improvement. Our Nursery Management System is an all-encompassing solution with features like: - Attendance tracking - Payment processing - Parent communication - Allotment - Student diary - Parent portal - Staff portal - Dashboard The ideal candidate will possess an understanding of the nursery and early years education sector. They should also have proven experience deploying, promoting or selling software systems or similar products ...

This project is focused on developing versatile robots that can perform diverse tasks. While the exact tasks were not specified, I presume a scope broad enough to include areas like cleaning, delivery, and surveillance, among other possible functionalities. Therefore, I'm looking for freelancers who are innovative, open-minded, and ready to take on a challenge. ...mechanical engineering is also welcome. - Systems integration knowledge could be useful in achieving necessary versatility. Please include in your application: - Your relevant experience particularly in robotics development. - Any previous works similar to this project. - Your approach or proposal for this project. Looking forward to meeting professionals who can bring innovative ideas to the table to make this pro...

I am seeking an artist to create abstract illustrations for rhymes th...specifically written these narratives for an age group of 3-5 years old, hence the illustrations should be designed keeping in mind this target audience. Ideal Skills & Experience: - Experience in illustrating children's books or related content - Strong artistic ability with strengths in abstract drawing - Understands how to make content appropriate and engaging for a pre-school age child The perfect freelancer will be able to bring these short, one-page rhymes to life in a joyful, engaging, and kid-friendly manner. It's important that the work does not follow a cartoon-like or realistic path but rather embraces an abstract art style. I look forward to seeing how you envision thes...

...Azure App Services, Azure Key Vaults, Azure Storage Accounts, Azure App Insights, Azure AD, Embedded PowerBI, and Kubernetes Advanced knowledge in implementing consumer-grade responsive web designs Advanced knowledge of relational databases, preferably Microsoft SQL Server Advanced knowledge of building SPA web development using React Intermediate to advanced knowledge of CSS pre-processing platforms, such as LESS and SASS Intermediate to advanced knowledge of API and back-end development technologies such as C#, .NET Core, and SQL Server Intermediate to advanced knowledge of performance testing frameworks Experience in using Azure AD security Strong communication skills including the ability to effectively communicate complex technical concepts to non-technical au...

Project Overview: Custom WordPress plugin required to allow a user to view data from 2 JSON data feeds & filter the results PHP Version: 8.2 and above Number of Shortcodes: 2 (we will be inserting the shortcode into various pages & posts to display the plugin functionality. Overview of plugin functionality: The purpose of this script is to retrieve a list of matching records from the db table & display this data in a clean and user friendly way. Process Flow: - Retrieve current postId - Dynamically insert the value into the GET data request for Feed URL #1 - display returned data in a clean & user friendly format. Design Requirements - Front end should be mobile optimised & responsive - All elements should have their own unique css class - The design s...

Delivery Project Front-End in Flutter or React Native (iOS and Android) where the customer finds shopping options, selects the payment method, completes the purchase, tracks, and receives the product. Flow with Figma will be provided, estimated at 50 screens. Back-End in NodeJs, SQL Server, or MongoDb. There will be connections with third-party Rest APIs. OAUTH 2.0 Authentication Merchant Portal: Java or React Native where merchants will have access to view orders, delivery control, product registration, store registration, opening hours, employees, vehicles, and other store customizations. In the same Portal, based on the access credential, the company will have the admin console to activate merchant accounts and other functionalities, such as account blocking and ge...

I'm looking for a talente...to help create a 10-30 minutes long, vector-based animation movie tailored for children. - Duration: The expected length of this animated movie should be between 10 to 30 minutes. - Animation Style: The chosen style will be a vector-based animation, known for its modern, crisp effect and flexibility. - Audience: The project will be targeted towards children, so the content and style should be child-friendly, engaging, creative, and fun. Ideal candidate would possess the following skills and experiences: - Proficiency in vector animation. - Experience in creating animations targeted towards children. - Exceptional storytelling, creativity, and understanding of pacing in animation. - Able to deliver work within deadlines and according to provided ...

Hello everyone, I hope you're doing well. I'm having some trouble with a map script I have. Specifically, when I select certain locations, I'm unable to see the corresponding points on the map. I need assistance in fixing this issue. If you're proficient in HTML, CSS, JavaScript, and Node.js, this should be a straightforward task. Please feel free to reach out to me. Thank you.

I'm in need of a talented animator to create a captivating, 3D animated video primarily focused on storytelling for children. My project requires: - Expertise in 3D animation, with a knack for creating understanding, appealing, and child-friendly visuals. - An ability to translate our narrative into a high-quality, engaging, and entertaining 3D animated video. - A solid understanding of storytelling principles, with prior experience in creating animated videos targeted at a children's audience. - A knack for effectively delivering the essence of a narrative through animation. From vivid characters to detailed environments, the ability to, not only recreate but to enhance the world within the story, is essential. Outstanding creativity and a deep understanding of children...

I am seeking a proficient developer experienced with SQL Server Reporting Services (SSRS), ASP.net, and MVC. The project involves the integration of SSRS reports onto a web platform using either ASP.net or MVC. Ideal skills and experience: - Strong understanding of SSRS - Proficiency in ASP.net and MVC - Experience in integrating SSRS reports on web platforms Specific Requirements: - The SSRS reports to be displayed on the web should allow for parameter input. - The parameter input for the SSRS reports will be implemented using internally passing parameters. If you have the desired skills and experience, I'd love to hear from you today.

I'm in need of a seasoned PHP Laravel developer for a project focused on database integration, specifically with MySQL. The core task for this engagement is query optimization. Skills and Experience required: - Profound expertise in PHP development - Familiarity and proficiency in MySQL - Proven track record of successful query optimization I'm looking forward to engaging with highly qualified and responsible individuals for swift, efficient implementation of this particular task.

My project revolves around a MySQL select query that is showing slower-than-desired execution times. I cannot provide the data as it has PII and is very large. Main issue is that for pulling 1 month of data it takes about 3 hours, regardless if it returns 500 rows or 500,000 rows. There is likely a required index that I cannot see. I will be providing 1) The query 2) The Explain Tree 3) The table definition from which it is pulling data.

As the lead on this project, I'm seeking a proficient coder with an extensive skill set including Python, NLP, and Open CV. Your objective will be to recreate the core functions of Vectorizer.ai. Consider this an opportunity to demonstrate your finesse in machine learning. Understanding how works and what you can bring to the table will be crucial. Your deliverable will be a full-fledged web application with an interface and functionalities that mirror Vectorizer.ai. Proficiency in relevant web development technologies will be an added advantage. Key Responsabilities: - Develop api like Vectorizer.ai. - Utilize Python, NLP, and Open CV for development. - Deliver a fully functional web application. While experience in NLP tasks was optional, any existing knowledge in the fi...

We're searching for an experienced bootstrap developer to transform the front end of our admin panel. The precise features and user interfaces aren't pre-set as we understand freelancers may bring novel and useful ideas alongside their toolkit. Required Skills: - Expertise in Bootstrap - Profi...Experience: - Past experience in developing and designing admin panel interfaces Application: - Links to your past work or portfolio - A brief outline of your approach to the project - Any creative ideas or proposals you might have for our admin panel Bear in mind that the main purpose of the admin panel is yet to be defined, presenting an opportunity to collaborate and bring your innovation to the table. Your role will be predominantly front-end, focusing on the overall design ...

Record not showing after filtered Filter issue. Just one table FTP only

I'm seeking a skilled Python developer to integrate my local project with a WordPress database. The immediate task involves retrie...the WordPress database in my local project. Key responsibilities: - Create a secure, reliable connection between my local project and a WordPress database using Python - Design and implement an efficient method for retrieving user account information - Ensure the retrieved data is displayed correctly within the local project Ideal skills: - Strong Python development skills - Experience with SQL and WordPress databases - Proven track record of creating database connections and retrieving data - Attention to detail in presenting the retrieved data in a user-friendly format Please note that the project's urgency is high and immediate comme...

...for managing multiple portfolios. - Dynamic results viewing with charts and tables for an in-depth analysis of investment performance. Technology Stack: - Frontend & Backend: v14, leveraging API routes for backend functionality if needed. - Styling: TailWind CSS v3 with DaisyUI v4 for a sleek, dark-themed UI/UX. - Data Visualization: ChartJS & react-chartjs-2 for charts, TanStack Table v8 for tables. - Additional Libraries: SWR & Axios for data fetching, Zustand for state management. The ideal candidate should have experience in developing complex web applications, a strong background in the technologies listed, and a passion for creating user-centric, data-driven applications. Please message me for the full details and requirements of this project if...

...platsic could be injection molded or cut from solid stock with CNC router this is a product design, not a simple pretty picture This is not a project for a graphic designers and artisits, it is a product design Key Responsibilities: - Create a detailed 3D model with high-accuracy and precision - Work closely with me on any necessary design revisions - Ideally, bring other design skills to the table for potential further collaboration Ideal Candidate: - Proven experience in product design, specifically electronics or electonic housings - Remarkable 3D modeling skills - ability to create engineering drawings of all parts - Meticulous attention to detail - Ability to meet deadlines effectively The resulting 3D model is intended to be intricate and highly faithful to our existi...

I need a talented and innovative graphic designer for creating an intriguing modern, strawberry based design. This design is a tribute to Oxnard, California - known worldwide for producing some of the ...Illustrator or CorelDRAW, and substantial knowledge in modern design style. Let's honor Oxnard's sweetest strawberries through your exceptional design skills! I have this as a foundation to go off. I am looking to create a version that has Oxnard overlapping with a strawberry, similar to how “tree factory” overlaps with the strawberry on the back. On the back I would like “tree factory” to be removed and I would like the strawberry to be underneath the “Oxnard” text as it is currently underneath the “tree factory ...

I'm currently looking for an HTML developer who has experience in photo editing and website design. I'm a student and I've been doing my own photo and video editing, but I now need a professional touch to create a website meant for selling products/services. Tasks would include, but not limi...limited to: * Photo editing * Web designing * Integrating these elements in a functional website REQUIRED SKILLS: * Excellent HTML knowledge * Advanced Photo editing expertise * Strong understanding of web design principles APPLICATION REQUIREMENTS: * Portfolio of past work * Detailed project proposal Even if you're just starting out, I'm interested in seeing what you can bring to the table. Especially if you can show me what you're capable of through ...

As a business owner targeting working parents and focusing on the care of newborns to three-year-olds, I'm looking for a professional to c...business owner targeting working parents and focusing on the care of newborns to three-year-olds, I'm looking for a professional to craft a comprehensive business plan. The primary goal is to secure funding. Ideal Candidate: - Experience in crafting business plans, preferably with childcare industry background - Understands nuances of funding applications in the UK - Can effectively target working parent demographic in Notting Hill in London, UK Key Details to Include: - Analysis and strategy for reaching working parents - Detailed operations guide, primarily aimed at handling babies to two-year-olds efficiently - Financial projecti...

I'm looking for a skilled developer with a knack for Unity game development. The goal is to create a game that can be played across multiple platforms, including PC, Mobile (iOS and Android), and Console. Though I'm open to ideas and suggestions, creativity and innovation are highly encouraged. Ideal Skills and Experience: Proficiency in Unity Experience with multi-platform game develop...following in your application: Portfolio of past work Details of relevant experience Creative and detailed project proposal This project is an open canvas, and I am particularly interested in integrating features that make the game unique and engaging. Shooting, puzzle-solving, and exploration mechanics are welcome. However, consider this as an opportunity to bring new concepts and ideas ...

...timestamps - Heading details - Velocity Along with the essentials, I’m interested in the following flight specifics: - ICAO24 - Callsign may need other data Potential freelancers should come with profound experience in data collection and understanding of ADS-B flight tracking data. A meticulous eye for detail and accuracy is critical for this task. Proficiency in languages such as Python, R, or SQL for data mining and analysis would be advantageous....

I'm looking for a skilled developer with a knack for Unity game development. The goal is to create a game that can be played across multiple platforms, including PC, Mobile (iOS and Android), and Console. Though I'm open to ideas and suggestions, creativity and innovation are highly encouraged. Ideal Skills and Experience: - Proficiency in Unity - Experience with multi-platform game d...following in your application: - Portfolio of past work - Details of relevant experience - Creative and detailed project proposal This project is an open canvas, and I am particularly interested in integrating features that make the game unique and engaging. Shooting, puzzle-solving, and exploration mechanics are welcome. However, consider this as an opportunity to bring new concepts and ideas ...

Looking for a creative and experienced furniture designer to help me develop unique concepts for various home use furniture including coffee tables, chairs, sofas and a dining table. Ideal Skills and Experience: • Proficiency in furniture design • Experience in designing residential furniture • Knowledge in working with wood and metal. Project Scope: • Develop innovative design concepts for a coffee table, chairs, a sofa and dining table • Material focus: wood and metal • The designs should fit seamlessly within a home setting. My ideal freelancer has a discerning eye, a passion for functional aesthetics, and experience in material exploration. Using your design experience and knowledge, your goal will be to create concepts that ...

We're searching for an experienced bootstrap developer to transform the front end of our admin panel. The precise features and user interfaces aren't pre-set as we understand freelancers may bring novel and useful ideas alongside their toolkit. Required Skills: - Expertise in Bootstrap - Profi...Experience: - Past experience in developing and designing admin panel interfaces Application: - Links to your past work or portfolio - A brief outline of your approach to the project - Any creative ideas or proposals you might have for our admin panel Bear in mind that the main purpose of the admin panel is yet to be defined, presenting an opportunity to collaborate and bring your innovation to the table. Your role will be predominantly front-end, focusing on the overall design ...

I'm seeking a python backend developer with proficiency in API integration and database management. The developer will be primarily responsible for: - Managing an SQL database, ensuring it runs optimally. - Seamlessly integrating APIs, and troubleshooting any issues that emerge. Ideal candidates should: - Possess a strong understanding of Python. - Have prior experience in database management using SQL. - Possess experience in API integration. Familiarity with server maintenance is a bonus, but not mandatory. Success in this project requires excellent problem-solving skills and meticulous attention to the fine details of backend coding.

I'm looking for a talented video editor with a knack for creating fast-paced, energetic videos. My new YouTube channel focuses on pop culture and music, and I need someone who can make the content pop, keeping viewers engaged throughout each short, less than 10 minute video. Your skill-set should include: - Fast-paced and energe...than 10 minute video. Your skill-set should include: - Fast-paced and energetic video editing. - Ability to create graphics and text overlays. - Incorporating music and sound effects strategically. A strong feel for rhythm in visual media and an understanding of pop culture and music themes will make you stand out. Your ability to continuously improve and bring fresh, creative ideas to the table is also a must. Let's create something ...

I'm on the lookout for a seasoned professional to manage my company's Facebook page. The ultimate goal is to enhance brand awareness through well-informed and engaging content. Key responsibilities: - Craft and schedule relevant, Informative p...- Proficiency in Facebook’s advertising platform, with a strong track record in leveraging Facebook to build a brand. - Strong understanding of content creation for promotional purposes. - Innovative thinking - ability to initiate, test, execute, and report strategies and experiments. - Proficiency in English for effective post creation and audience engagement. In bringing these skills to the table, the perfect candidate will help build brand recognition, fostering a solid community by offering valuable, informative conte...

...lifelike visuals to the point that the friend can't tell it's a deepfake. Prior experience in creating such precise deepfake videos is desired. - Completed ASAP – time is of the essence for this project. Prospective freelancers should have a strong portfolio of similar projects and may need to accommodate rapid revisions to ensure a satisfactory outcome. I'm excited to see what you can bring to the table!...

Wanting to lift the quality of my company's blog and product descriptions to new levels, we are looking for someone with: - Proven abilities in writing engaging blog posts and thoroughly detailed product descriptions. - Ability to handle a workload of more than 10 blog articles, each 1000-1500 words long. Your creativity and adaptability in crafting high-quality, unique, and engaging content ... - Proven abilities in writing engaging blog posts and thoroughly detailed product descriptions. - Ability to handle a workload of more than 10 blog articles, each 1000-1500 words long. Your creativity and adaptability in crafting high-quality, unique, and engaging content will be invaluable in this collaboration. Please bring your strong work ethic, timeliness, and passion for writing to th...

I'm urgently in need of a freelancer skilled in iOS and Android application development. The main aim here is to create an app that provides users with live soccer scores. This has to be both mobile and user friendly. You must bring to the table: - Extensive experience in designing apps for both iOS and Android platforms. - Exceptional UI/UX design skills to ensure user friendliness. - Polyglot coding skillset (namely Swift, Objective-C, Java, Kotlin). - Previous experience developing live score apps or related will be a plus. - Ability to work under time pressure as the project needs to be completed ASAP. - Willingness to cooperate with me should there be need for any adjustments.

...display collapsable ratio in weight Weight: 600, Price: 1800, status: active, inactive // inactive Items can’t be selected. } Schedule: { Id: 1, customerId: 1, DeliveryScheduleId: 1, deliveryConsistencyInHours: 120hrs minimum, Status: active, inactive, paused, canceled // canceled, paused or inactive Schedule can’t receive deliveries. } DeliverySchedule: { Id: 1, itemId: 1, scheduleId: 1, <<< parent deliveryDate: dateTime, deliveryTime: { start: 10:00am, end: 3:00pm}, Status: pending, completed, canceled } // a customer can canceled, if a schedule is paused and the delivery schedule date and end date has passed then this is automatically canceled. A canceled DeliverySchedule must not receive deliveries. A completed DeliverySchedule is when a customer ...

I'm seeking an...for a custom design project. This isn't about logo, poster, or packaging design—it's something distinct, so your ability to think outside of these boxes is crucial. Key requirements and skills: - Inventiveness: Ability to create something beyond the traditional designs. - Broad Skillset: Since the project isn't defined by common categories, you should bring a wide range of design skills to the table. - Communication: I don't have a set style or concept in mind, so communication will be vital. Your ability to take abstract ideas and transform them into tangible designs through dialogue is key. If you're an experienced designer willing to embrace ambiguity in the pursuit of unique designs, I welcome you to bid for this project. Le...

...nursery. Design Relevant Details: - The interior design should follow a modern style - The nursery ought to include an area for playing, an educational section, and a resting area Cafe & Coworking Extras: - The café/coworking space should offer a catering service. Ideal Candidate: - Strong portfolio in modern interior design - Experience with multifunctional spaces - Background in designing child-friendly environments - Understanding of ergonomic and efficient catering space requirements. For more info about the project: www.cristabelas.com...

...minimalist logos for our new coffee shop and hair/nail salon. The perfect execution will align with our chosen colors and incorporate some specific symbols. Key Tasks: - Design one logo for a coffee shop; one for a salon - Keep designs simple, minimalist and modern - Utilize specified colors: olive green, sand, brown, rust red (coffee shop) and plum (salon) Specific Elements: - Integrate a dates palm tree into the coffee shop logo - Incorporate berries into the salon logo Ideal Skills: - Experience in minimalist logo design - Excellent color comprehension and execution - Ability to creatively integrate symbols into designs Your creative suggestions are welcome to add more appeal to our logos. Let's bring our brand identities to life together! Attached designs we kind...