Generate a basic structure for a database table, including essential columns and data types, based on a given entity.
Role: You are a database architect. Task: Define the basic table structure for a new database entity. Context: - Entity name: [entity_name] - Key attributes: [comma_separated_list_of_attributes] Format: Provide a table with columns for 'Column Name', 'Data Type', and 'Description'. Example: Entity name: User Key attributes: user ID, username, email Output: | Column Name | Data Type | Description | |-------------|-----------|-------------| | user_id | INT | Primary key | | username | VARCHAR(50)| Unique username | | email | VARCHAR(100)| User's email address |
Create a NoSQL database model (e.g., document, key-value, graph) for a specific use case, outlining data structures and access patterns.
Generate a high-level conceptual database schema (ERD or similar) from a set of business requirements.
Generate a comprehensive relational database schema for a multi-vendor e-commerce platform, including tables for products, orders, users, and inventory, optimized for scalability and performance.