data - master - urait/auction

data
106 строк3 KB
urait
create data
05 апр 2025, 07:55
05 апр 2025, 07:5548c004a
# Untitled Diagram documentation
## Summary

- [Introduction](#introduction)
- [Database Type](#database-type)
- [Table Structure](#table-structure)
	- [auction](#auction)
	- [user](#user)
	- [bid](#bid)
	- [record bid](#record bid)
- [Relationships](#relationships)
- [Database Diagram](#database-Diagram)

## Introduction

## Database type

- **Database system:** MySQL
## Table structure

### auction

| Name        | Type          | Settings                      | References                    | Note                           |
|-------------|---------------|-------------------------------|-------------------------------|--------------------------------|
| **id** | INTEGER | 🔑 PK, not null, unique, autoincrement |  | |
| **auto** | TEXT(65535) | null |  | |
| **date_time** | DATETIME | null |  | |
| **id_record_bid** | INTEGER | null |  | |
| **status** | INTEGER | null |  | | 


### user

| Name        | Type          | Settings                      | References                    | Note                           |
|-------------|---------------|-------------------------------|-------------------------------|--------------------------------|
| **id** | INTEGER | 🔑 PK, not null, unique, autoincrement | fk_user_id_bid | |
| **name** | VARCHAR(100) | null |  | |
| **last_name** | VARCHAR(100) | null |  | |
| **password** | TEXT(65535) | null |  | |
| **date** | DATETIME | null |  | |
| **status** | INTEGER | null |  | | 


### bid

| Name        | Type          | Settings                      | References                    | Note                           |
|-------------|---------------|-------------------------------|-------------------------------|--------------------------------|
| **id** | INTEGER | 🔑 PK, not null, unique, autoincrement | fk_bid_id_record bid | |
| **id_user** | INTEGER | null |  | |
| **price** | FLOAT | null |  | |
| **status** | INTEGER | null |  | | 


### record bid

| Name        | Type          | Settings                      | References                    | Note                           |
|-------------|---------------|-------------------------------|-------------------------------|--------------------------------|
| **id** | INTEGER | 🔑 PK, not null, unique, autoincrement | fk_record bid_id_auction | |
| **date** | DATETIME | null |  | |
| ** id_bid** | INTEGER | null |  | | 


## Relationships

- **user to bid**: one_to_one
- **bid to record bid**: one_to_one
- **record bid to auction**: one_to_one

## Database Diagram

```mermaid
erDiagram
	user ||--|| bid : references
	bid ||--|| record bid : references
	record bid ||--|| auction : references

	auction {
		INTEGER id
		TEXT(65535) auto
		DATETIME date_time
		INTEGER id_record_bid
		INTEGER status
	}

	user {
		INTEGER id
		VARCHAR(100) name
		VARCHAR(100) last_name
		TEXT(65535) password
		DATETIME date
		INTEGER status
	}

	bid {
		INTEGER id
		INTEGER id_user
		FLOAT price
		INTEGER status
	}

	record bid {
		INTEGER id
		DATETIME date
		INTEGER  id_bid
	}
```