webnovel
simple flower design

simple flower design

Forgotten Legend of the Bloodied Flower

Forgotten Legend of the Bloodied Flower

“Live the life you want this time.” A peerless assassin, codename: Hua, has already started her career ever since she was a child. Her mission’s record was perfect and whoever deemed to be her enemies would end up dead without knowing why. When war ended, she was sent to an institution where she was watched heavily. The doctor in charge gave her an ordinary wuxia novel to read. An avalanche struck after she had finished reading. When she woke up, she had turned into Nan Hua, the young miss of a powerful military family in the novel she read. The girl was also the former main character’s fiancée, who would die because of obstructing the main character’s love. Now that she had taken over, who would dare to act so presumptuously around her? They would never know how they ended up so miserably! But… main character, what are you doing loitering around her? Shouldn’t you focus on the impeding war and saving your female lead? Why are you trying all ways to win her instead, ah? ... Story set in fictional world with similar culture to Ancient China. Join the discord to chat with the author and other readers: https://discord.gg/pBy2wGB ... P.S: This story is published in Amazon too, if you do read there, kindly leave a review please. Thank you ^^ ... Sequel: Astral Flower [on going] ... Other novels: -Flowers Bloom from Battlefield [complete] - Under the Veil of Night [complete] - 7 Path of the Lilies [on long hiatus] - 1 Year of Beginning [complete] - Villain Lady [complete] - Science and Fantasy [complete] - 2 Years of Restarting [complete] - The Quiet Empress [on going] - The Villain's Little Cat [on going] ... Follow me on IG: @sora100518
History
2750 Chs
Schemes Of A Flower

Schemes Of A Flower

Crown Prince Yun Chi chose as his consort the youngest daughter of the Hua Family, Hua Yan, and the news shattered the hearts of countless ladies in the Capital City. It was said: the Crown Prince could write poetry at three, compose essays at seven, debate with the greatest scholars at ten, shoot arrows with precision at twelve, oversee the examinations of all scholars at fifteen, and was regent by the time he was sixteen. He reached the pinnacle in letters, the extreme in martial arts, his looks were world-shaking, and his presence unrivaled. Hua Yan felt as though a gigantic pie had fallen from the sky, landing squarely on her head. From then on, was she to compete with the entire world for this man? -------------------- Yun Chi: Standing at the pinnacle of the Azure Clouds, he learned the art of balance, practiced the strategies of an emperor, envisioned the land and skies in his heart. Within the nine-layered royal palace, he could turn his hands to clouds and his palms to rain, holding sway over the court and the nation, trimming himself into a figure free from desire and henceforth unyielding. Hua Yan: She viewed herself as beneath the dust, with all her emotions and desires, disliking the Son of Heaven's court, preferring the ordinary alleys, treading on ten feet of soft red and experiencing all facets of life. She believed that nothing was better than green mountains and clear waters. "If you promise me a lifetime, I will accompany you for an eternity."
General
856 Chs
Design a simple mascot
Here are the basic steps to designing a simple mascot: ** 1. Confirm theme and concept ** 1. ** define roles ** - First of all, it was necessary to clarify what the mascot represented, such as a company, an event, or a region. If it was a coffee shop, you could consider using coffee-related elements as the theme, such as coffee beans, coffee cups, and so on. 2. ** Excavate Unique Attributes ** - Find out what was unique about this theme. If it was a city's mascot, consider the city's famous landmarks, cultural features, or traditional crafts. For example, the mascot of the Hangzhou Asian Games,"Memories of Jiangnan", incorporated Hangzhou's cultural elements. ** 2. Construct image ** 1. ** Choose basic shape ** - Simple geometric shapes were a good starting point. For example, a circle could give people a cute and friendly feeling, which was suitable for mascots with strong affinity, while a triangle could convey vitality and movement. If the image was based on a coffee cup, it could be a round cup with a triangular handle. 2. ** Add Unique Elements ** - Add iconic elements according to the theme. For the coffee cup mascot, you can draw some coffee bean patterns on the cup, or let the mouth of the cup emit a heart-shaped hot air, indicating that the aroma of coffee is attractive. 3. ** Consider personification ** - Give the mascot human characteristics, such as eyes, arms, legs, etc. The eyes were a very important part. They could make the mascot more vivid and intimate. Just like the emphasis in mascot design, most mascots needed eyes to close the distance between them and the audience. ** 3. Confirm the color ** 1. ** Color Association ** - Choose a color that is relevant to the theme. For coffee-related mascots, brown was very suitable because brown reminded people of the color of coffee. If it was a mascot representing vitality, you could choose bright colors such as red, orange, and so on. 2. ** Color matching principle ** - The main color, auxiliary color, and emphasis color could be used. The brown mascot could use white as an auxiliary color to draw the decorative lines of the cup body, and gold as an emphasis color to highlight some special parts, such as the highlight on the cup handle or coffee beans. ** 4. Perfect the details and naming ** 1. ** Details handled ** - The overall image of the mascot was refined to check if the lines were smooth and if the elements were harmonious. You can add some small details to the mascot, such as drawing a small smiley face on the coffee cup to make it look more friendly. 2. ** Name ** - Give the mascot a name that is easy to remember and relevant to the theme. As for the coffee cup mascot, it could be called " Coffee Treasure " or something like that. While watching the Olympics, you can also read the wonderful novels related to the Olympics!
1 answer
2026-07-24 08:20
How to write a simple online celebrity design plan for a small flower shop?
The following is a simple Internet celebrity design plan for a small flower shop: ** 1. Sign and window design ** 1. ** Sign ** - It was a combination of artistic floral decorations and a drawing board. It was placed outside the flower shop to form a signboard full of artistic atmosphere to attract the attention of customers. 2. ** Showcase ** - The display window was the key location to display the flower shop's floral skills. Choose attractive floral works and ornaments to display. These works must stimulate the customer's desire to enter the store. ** 2. Overall Color Selection ** - It was best to avoid colors that were too saturated and had a strong contrast. This was because high saturation and strong contrasting colors could be visually overwhelming and messy, and it was easy to cause the flowers to conflict with the background when taking photos. The specific color tone was determined according to the overall style of the flower shop and the owner's preferences. ** 3. Storage rack display ** 1. ** Function Requirements ** - The shelves should be practical, firm, and flexible, so that it was convenient for the flower arranging staff to operate and the customers to visit. At the same time, they should meet the different needs of various flowers. It was not only used to display, display, and sell flowers, but also to accommodate and store flowers to ensure that flowers were easy to choose and convenient to take and place. 2. ** Style Match ** - The display should match the style of the flower shop and display the unique style of the flower shop through the shelf display. ** IV. Pipings and Circuit Layouts ** 1. ** Water supply pipe ** - The water supply pipe should be exposed as much as possible to facilitate daily operation and maintenance. He could build a small reservoir to soak the flower mud and use it as a first-aid pool for the flowers. 2. ** Route ** - As for the regular power cables, lighting cables, network cables, telephone cables, air-conditioning cables, etc., except for the power cables that should be distributed in the display window, exhibition area, cashier, and work desk to ensure convenient electricity usage, the rest of the cables should be concealed as much as possible to prevent damage. ** 5. Lighting Design ** 1. ** Lighting Requirement ** - The lighting should be bright and warm. 2. ** Lamp selection ** - It was recommended to use LED lights, which were energy-saving and cost-effective. Moreover, they were cold light sources, which could prevent the temperature of the lights from causing the flowers to bloom early. ** 6. Spatial layout and functional divisions (if space permits)** 1. ** Exhibition Area ** - Rationally plan the display area, display different types and styles of flowers, floral works, and flower utensils through ingenious layout, attract customers 'attention and guide them to browse in the store. 2. ** Operation area (if some operations are open to customers)** - Keep the operation area clean and orderly, and separate it from the customer activity area appropriately. It is convenient for employees to operate and allow customers to see the process of making flowers. 3. ** Rest Area (Option)** - If there was enough space, a small rest area could be set up with some comfortable seats. Customers could rest here, admire flowers, or exchange floral knowledge with the owner. ** 7. Adding Unique Elements ** 1. ** Clock in point ** - Design a unique checkpoint, such as a unique flower wall or a creative floral corner, so that customers could take photos and share them on social platforms to attract more potential customers. 2. ** Themed Elements ** - According to different seasons or special festivals, the corresponding theme elements were integrated, such as the love element of Valentine's Day, the Christmas element of Christmas, etc., so that the flower shop had a unique atmosphere at different times. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>
1 answer
2026-08-04 18:55
Design a username with "Flower","Flower" and "Monogatari"
For screen names with "Flower","Flower", and "Monogatari", you can refer to the following examples: 1. Flower language: The beauty and mystery of the flowers also hinted at the richness of the story. 2. Flower Sea Monogatari: Combining the sea of flowers and the monogatari gives people a romantic and mysterious feeling. 3. Blooming Flowers: Simple and clear, meaning the variety of life. 4. Hanamonogatari: Combining Hanamonogatari and Monogatari gives people a fresh and natural feeling. 5. Flower Story: A story about flowers with flowers as the main character to convey a fresh and natural emotion. 6. Garden Story: Combining the garden and the story together gives the feeling of being in the garden. 7. Hanagami Monogatari: Narrates a mysterious monogatari with Hanagami as the protagonist, giving people a mysterious and beautiful feeling. 8 Flower Soul Monogatari: Combining Flower Soul and Monogatari gives people a mysterious and romantic feeling. 9 Flower Alliance: A flower themed alliance symbolizes unity and cooperation. [Flower Story: A mysterious story about nature and life with flowers and stories as the main characters. It conveyed a feeling of reverence for nature.]
1 answer
2024-09-19 18:47
Flower Terrace Design
The following are the key points related to the design renderings of several common flower terrace designs: ** 1. Different flower terrace designs ** 1. ** Regular Flower Terrace Landscape ** - The shape of the plantation platform was a regular geometric shape, such as a cube, a drum, a cylinder, a prism, and other shapes with geometric lines. It could be a single flower stand or a combination of multiple flower stands. The pedestal was more gorgeous than the flower bed. It could create a simple, neat, and symmetrical visual effect through this regular shape. It was suitable for modern or European-style courtyards, plazas, and other places. 2. ** Natural Flower Terrace Landscape ** - The pedestal's outline was an irregular natural shape, mostly made of natural mountain stones, such as lake stone, yellow stone, Xuan stone, Ying stone, etc. The design of this kind of flower terrace was free and flexible. It was easy to harmonize with the surrounding natural scenery. It was commonly seen in classical gardens and gave people a natural, simple, and rustic feeling. It was suitable to be placed in courtyards and gardens with natural landscape elements. It was convenient for people to appreciate the beauty of the combination of flowers and rocks up close. 3. ** Independent flower terrace landscape ** - The outline of the plantation platform could be a regular geometric shape or a variable shape, and it could be arranged alone in a certain space to form a landscape. Using stone blocks to build could give a natural, rough, elegant, and generous effect. Although the pedestal's shape was rich and gorgeous, it should be careful not to be too gorgeous so as not to deviate from the floral theme. It could be used as an independent focus in the space, such as in the corner of the courtyard, the entrance of the building, and so on. 4. ** Combined Flower Terrace Landscape ** - It was composed of multiple platforms. There were two types of combinations: flat combination (each platform was on the same ground) and three-dimensional combination (each platform was located at different heights and were scattered). When three-dimensional combination, you must pay attention to the balance and stability of the local shape and the overall shape. It could also be matched with chairs, stools, sculptures, structures, etc. to form a multi-functional landscape. It was suitable for larger courtyards, public leisure areas, etc. to increase the sense of layering and interest of the space. 5. ** Symsymmetrical flower terrace landscape ** - The planting platform was mostly shaped into a geometric shape, which was arranged symmetrical on both sides of the gate, road, and a certain landscape to form a pair of scenery. This kind of layout had a relatively ornamental effect, giving people a balanced, solemn, and stable visual experience. It was often used at the entrance of formal gardens and the two sides of the square in front of large buildings. ** 2. The influence of other elements in the flower terrace design on the renderings ** 1. ** Plant selection and matching ** - Plants were chosen according to the seasons, color combinations, and growth habits. Flowers that bloomed in different seasons and green leafy plants that bloomed in all four seasons could ensure that the flower stand had ornamental value at different times. For example, cherry blossoms, peach blossoms, and other flowering trees could be chosen in spring, paired with tulips, hyacinths, and other herbaceous flowers; in summer, crape myrtle and hibiscus could be paired with rose and jasmine; in autumn, chrysanthemums and red maples could complement each other; in winter, cold-resistant plants such as wintersweet could be used alone. Through a reasonable combination of plant species, it could create a rich and colorful landscape effect, which greatly affected the overall visual effect of the flower terrace. 2. ** Colors and visual effects ** - The clever use of color matching was the key to the design of the flower terrace. Different color combinations could create different ambiances. For example, contrasting red and green could create a lively and eye-catching effect, while matching similar colors could create a harmonious and soothing atmosphere. In addition to the color of the flowers, it could also be embellished with the color of the leaves and fruits of the plants to enrich the color level of the flower platform. 3. ** Material and texture ** - The choice of material would change the overall style of the flower terrace. For example, natural stone, porcelain, glass, and other materials could be used to increase the texture and ornamental value of the flower terrace. For example, natural stone gave people a simple and heavy feeling, porcelain might be more exquisite, and glass could bring a modern and transparent feeling. At the same time, he had to pay attention to the adaptability of the material and the plant growth environment to avoid adverse effects on the plant. 4. ** Maintain and manage ** - In the long run, regular trimming, fertilising, watering, and pest control were essential to maintain the beauty of the flower bed. If it was not well maintained, the plants would grow messily, and pests would breed. This would destroy the original intention of the flower terrace design and affect its ideal visual presentation in the renderings. The novel "Mixed Flowers" is equally exciting. Everyone is welcome to click and read it!
1 answer
2026-03-25 20:17
The design of the Martian base was simple.
The following are some of the simpler design concepts for the Martian base: ** I. Design by ICON and NASA ** 1. ** Overall layout ** - It was a relatively compact space with an area of 158 square meters. There was a 55-inch TV inside to satisfy entertainment needs. - A gym was included to meet the exercise needs of the residents, which helped to maintain physical functions in the relatively low gravity environment of Mars. - There was an indispensable area for growing vegetables. This was to achieve self-sufficient food and solve the problem of food supply on Mars. 2. ** Construction Techniques ** - 3D printing technology was the first choice for building a habitat. Because of the lack of building materials on Mars, 3D printing could effectively use limited material resources. ** 2. Design by China Open Construction Firm and Xiaomi ** 1. ** Overall layout ** - The exterior looked like a combination of a steampunk style camper and an alien cockpit, and the overall space was compact. - The interior was minimalistic and functional. There was a main living area that looked like a bathroom with tables, chairs, and storage areas. - He could use his mobile phone to control the electrical appliances in his home, such as lighting, which showed the characteristics of intelligence. 2. ** Special Attribute ** - This was a self-circulating, zero-pollution residence. Based on the extreme transportation size of 2.4m*2.4m* 2m, it could be flexibly expanded with the thinnest inflatable material. ** 3. First prize in NASA's Mars Habitat 3D Print Challenge (SEArch+/ api Cor team)** 1. ** Overall layout ** - It was a spiral four-story building. This design could achieve a larger living and functional space on a limited land area. 2. ** Construction Techniques ** - The 3D printed Mars base required the use of existing local materials or waste from space missions to complete the construction. This design may follow the requirements for material planning and layout. The novel "Mars of Paradise" is equally exciting. Everyone is welcome to read it!
1 answer
2026-01-19 06:07
Design a simple mascot school
Here are the basic steps to designing a school mascot: ** 1. Confirm design inspiration ** 1. ** School's Unique Elements Excavated ** - Considering the geographical location of the school, if the school was located by the sea, perhaps elements such as marine life and waves could be incorporated into the mascot design. If the school was located in a mountainous area, mountains, trees, small animals, etc. could be used as reference objects. - The school's history and culture, such as having a long history, or being related to specific historical events and people, could become a source of creativity. For example, if a school was founded by a famous teacher, the image of the teacher could be incorporated into the mascot in the form of a cartoon. - The academic advantages of schools, such as science and technology schools, could use robots, scientific experimental instruments, and other elements, while art schools could get inspiration from art-related items such as brushes and musical notes. 2. ** Audience preference research ** - The main audiences of the school, namely students, teachers, and parents, were investigated. Students may like cute, lively, and modern images, such as anime style animals or superheroes; teachers may prefer images that reflect educational significance and positive values; parents hope that the mascot can show a positive image of the school and have a positive guiding effect on their children. ** 2. Choose the form of presentation (2D or 3D)** 1. ** 2D Mascot ** - The advantage was that the design and production were relatively simple, and it was easy to modify. If the budget was limited or the design time was short, the 2D mascot could be prioritized. For example, to design a simple cartoon animal image, you only need to use a drawing software (such as Adobe Illustrator or the free open source drawing tool Inkscape) to draw the basic shape, color, and expression. - It could be easily applied to print promotional materials, such as school pamphlets, posters, websites, etc. 2. ** 3D Mascot ** - Although the production process was more complicated, it was more three-dimensional and realistic. It would be better to display it in large-scale school activities (such as school celebrations, sports games, etc.). If there was enough budget and time, he could make a three-dimensional mascot. For example, to create a 3D mascot doll based on the school emblem, one needed to go through the steps of modeling (you could use 3D modeling software such as Benders), adding materials, rendering, and so on. ** 3. Design the appearance of the mascot ** 1. ** Overall shape ** - If he chose an animal image, it could be a common animal in the area where the school was located, such as local unique birds, small mammals, etc., and the shape could be simplified and cartoonized. For example, he could adjust the bird's body proportions to make it more rounded and enlarge its head to highlight its cuteness. - It could also be a creative shape that combined many elements, such as combining the shape of a book with the body of an animal. It implied that the school was a temple of knowledge, and the animals represented vitality and vitality. 2. ** Color matching ** - Choose a color that matches the school's image. If the school had a specific representative color, such as the color of the school emblem, then the main color of the mascot could be the color of the school emblem, with some auxiliary colors to increase the layering and attractiveness. For example, the school badge's main color was blue, and it could be used as the main color tone, paired with white, yellow, and so on as the color of the eyes, mouth, or decorative elements. - Colors should take into account the display effect on different media to ensure that they could be clearly and beautifully presented on printed matter, electronic screens, and so on. 3. ** facial expressions and details ** - Give the mascot positive and friendly facial expressions, such as big eyes (eyes are the windows to the soul, which can make the mascot look more energetic and friendly), smiling mouth, etc. - Add some details to reflect the school's characteristics, such as printing the school emblem or the school's name on the mascot's clothes. If the school was good at sports, they could add details such as sports equipment to the mascot. ** 4. Give the mascot personality and meaning ** 1. ** Personal traits ** - Confirm the mascot's personality, such as optimism, intelligence, courage, etc. These characteristics could be reflected through the mascot's actions, expressions, and stories. For example, designing a smart mascot could make it wear glasses, hold a book, and think. - Let the mascot have a unique catchphrase or iconic action, such as making a cheering gesture every time he appeared and saying an encouraging word. 2. ** Symbolism ** - The mascot must represent the school's values, such as unity, progress, innovation, and so on. If it was a symbol of unity, the mascot could be designed to always appear with other small partners (it could be a derivative image of the mascot or other cartoon characters) to help each other. - If it was related to the school's educational goals, for example, the school focused on cultivating students 'creativity, then the mascot could be described as a creative little inventor with all kinds of novel inventions. ** 5. Carry out copyright registration and other related work ** 1. ** copyright protection ** - After the design of the mascot was completed, it was necessary to register the copyright in time to protect the school's intellectual property rights to the mascot. In China, you can apply through the National copyright bureau or the relevant copyright registration agency. - Clearly define the scope of use and authorization of the mascot to avoid unauthorized use or copyright violation. For example, the school could specify that the mascot could only be used within the scope of the school's official activities and promotional materials. If it was needed for external commercial use, it must be authorized by the school. While watching the Olympics, you can also read the wonderful novels related to the Olympics!
1 answer
2026-07-21 19:04
A Flower Simple Drawing
Here are the steps for a simple flower drawing: 1. [Shaping: Use a 2B pencil to draw the shape of the flower. Pay attention to the position of the flowers (if it is a single flower, pay attention to the shape and proportion of the flower itself).] 2. Coloring (if using watercolor): You can first use a light yellow watercolor, add more water, and dye the color of the flowers. If you want to in-depth portray the color of the flowers, then use yellow, and add less water. Use earthy red and add a little water to draw the color of the stamen. If the bottom petals are affected by the environment, you can use yellow-green to draw the environment color of the bottom petals. 3. Painting branches and leaves (if there are): First use yellow-green, add a little water, and dye the color of the branches and leaves; then use dark green watercolor, add a little water, and paint the color and shape of the branches and leaves. Or take roses as an example: 1. First, he wrote an S and then drew a spiral line to connect them. 2. Write an inverted V and then three more. 3. He drew the flower stem and leaves, and finally, he drew the small thorns. Or draw a lotus flower: first draw the flower path and lotus leaf, draw the leaf vein, and finally draw the lotus seed with the oval and the letter U. The novel "Flower in the Heart" is equally exciting. Everyone is welcome to click and read it!
1 answer
2026-03-27 06:53
Draw a simple flower
Here are a few ways to draw simple flowers: - Method 1: First draw a circle, then write five 1's, connect them with arcs, then write another 1, draw a leaf, and a small red flower is completed. - Method 2: Draw an oval, write a u, then a small u, and draw two arcs. First, he drew the petals inside the U. The tip of the petals had a wavy line. Then, he drew the petals inside the oval behind it. He added the pattern with a small short line. After adding the flower clams and leaves, he erased the auxiliary line and painted the color. - Method 3: If you want to draw creative flowers (take three flowers as an example, each flower has five petals), use a 02 syringe pen or a gel pen to draw on a folding book (paper is rice paper). First, start from the middle flower, determine the position of the center, then draw the stamen from the middle point to the side, and draw the petals after the stamen is drawn.(The lines of the petals are undulating, and the front petals can be turned over); draw the flowers below on this basis, paying attention to the blocking relationship between the flowers; after the flowers are drawn, draw the big leaves close to the petals.(Pay attention to the difference between the top and bottom of the leaves and the size of the leaves). You can draw a small leaf above the small flower in the upper left corner, and add a dot in the lower right corner to decorate it (the dot can be drawn into a triangle, square, diamond, star, etc.). Finally, you can draw the main line along the vein in the middle of the leaf to both sides for details. You can also draw some vertical lines at the bottom of the flower for decoration. The novel "Flower in the Heart" is equally exciting. Everyone is welcome to click and read it!
1 answer
2026-01-28 00:36
Flower Border Design and Renderings
The following are some key points related to the design and renderings of the flower border: - In terms of style and theme, different flower border designs and renderings would have different performances. For example, the design for the low-water garden theme would include low-maintenance plants such as sedums (such as 'Autumn Joy' and 'Ruby Glow') and stachys woolens. These plants could adapt to direct sunlight and well-drained soil, and could maintain a good appearance in dry conditions. - In terms of color, the selection of colors for the ornamental grass flower border was generally based on the plants in the season. The span should not be too large, and the main color usually did not exceed three. The colors had to be coordinated to avoid too many colors clashing and not being able to highlight the theme. An excellent design was to simulate nature without being messy, and occasionally have bright colors as embellishments. - In terms of plant combination, he needed to choose plants with similar habits. For example, bulbous flower borders, succulent flower borders, ornamental grass flower borders, etc. By combining plants with the same habits, they could form a unique feature, reduce maintenance costs, and ensure long-term viewing. If the combination of plants with large differences in habits, such as succulents and bulbous flowers, sunny plants and shade plants, and Woody plants and clumps of herbs, although they might be beautiful for a while, it would increase the cost of later maintenance and even require replacement of plants. - In terms of layering, excellent flower border works would maintain the natural form of different plants, pay attention to the natural beauty of the plants, reflect the effect of natural planting, and have a well-arranged and regulated growth area, instead of presenting the effect of flattening, obvious color blocks, and plants all on the same level. For specific flower border designs and renderings, you can refer to some online resources. For example, there are 20 flower border designs with a list of plants that can be used as a reference for design drawings. There are also flower border renderings of Hetang landscape for you to view. Fantasy Realm is equally exciting. Everyone is welcome to click and read it!
1 answer
2026-07-03 17:42
Simple online bookstore database design
The database design of the online bookstore should include the following components: 1. Item Information Table (Item) -Store the basic information of the item such as title, author, price, description, classification, etc. 2. Order Information Table ( Order) -Store the order information of the customer, including the order number, customer name, order status, order items, etc. 3. Stock-Storage of stock information, including item number, stock quantity, purchase date, supplier, etc. 4. Order Management-used to record all orders created, modified, deleted, and the status of the order (completed, in progress, not processed, etc.). 5. Customer Information Form-used to record the basic information of the customer, such as name, email address, telephone number, etc. 6. The payment information table-used to record all payment methods such as credit card, AliPay, Weixin Pay, etc. 7. The supplier information sheet-used to record the basic information of the supplier, such as company name, address, contact information, etc. The following is a simple online bookstore database design example. The product information table, order information table, and inventory information table already include some basic data fields: ``` --Item Information Form (Product) CREATE TABLE Product ( Product_ID INT PRIMARY KEY Product_Name VARCHAR(50) NOT NULL Product_Price DECIMAL(10 2) NOT NULL Product_Description TEXT NOT NULL Product_category VARCHAR(20) NOT NULL FOREIGN KEY (Product_ID) REFERENCES Product(ID) ); --Order Information Form (Order) CREATE TABLE Order ( Order_ID INT PRIMARY KEY Customer_Name VARCHAR(50) NOT NULL Order_Status VARCHAR(20) NOT NULL Order_Product VARCHAR(50) NOT NULL Order_Time TIMESTAMP NOT NULL FOREIGN KEY (Order_ID) REFERENCES Order(ID) ); --Storage Information Form (Stock) CREATE TABLE Stock ( Stock_ID INT PRIMARY KEY _ Arrival_Date Date NOT Empty <strong></strong><strong></strong> FOREIGN KEY (Stock_ID) REFERENCES Stock(ID) ); --Order Management CREATE TABLE Order Management ( Order_ID INT NOT NULL Order_'s status VarCHAR(20) NOT nil Order_'s method VARCHAR(20) NOT nil FOREIGN KEY (Order_ID) REFERENCES Order(ID) ); --Customer Information Form CREATE TABLE Customer ( Customer_ID INT NOT NULL Customer_Name VARCHAR(50) NOT NULL Customer_Email VARCHAR(100) NOT NULL Customer_Phone VARCHAR(20) NOT NULL FOREIGN KEY (Customer_ID) REFERENCES Customer(ID) ); --payment information form (Payment) CREATE TABLE Payment ( Payment_ID INT NOT NULL Payment_Name VARCHAR(50) NOT NULL Payment_Type VARCHAR(20) NOT NULL Payment_Time TIMESTAMP NOT NULL FOREIGN KEY (Payment_ID) REFERENCES Payment(ID) ); ``` In the above design, each table has a unique ID as the primary key to ensure the uniqueness and integrity of the data. At the same time, in order to support multi-currency transactions, the payment information table also included a payment type field to distinguish different payment methods.
1 answer
2024-09-22 16:15
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z