Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Créer le schéma de la base de données #3

Open
3 tasks done
SamuelGuillemet opened this issue Sep 7, 2022 · 7 comments
Open
3 tasks done

Créer le schéma de la base de données #3

SamuelGuillemet opened this issue Sep 7, 2022 · 7 comments
Assignees
@SamuelGuillemet @xanode
Labels
documentation Improvements or additions to documentation enhancement New feature or request
Milestone
HORS VERSION

Comments

@SamuelGuillemet
Copy link
Collaborator

SamuelGuillemet commented Sep 7, 2022 •
edited
Loading

Schéma

  • [] Gestion des tenues
  • Intronisés
  • Stock
  • Tréso

#3 (comment)
@SamuelGuillemet SamuelGuillemet added the enhancement New feature or request label Sep 7, 2022
@SamuelGuillemet SamuelGuillemet added this to the HORS VERSION milestone Sep 7, 2022
@SamuelGuillemet
Copy link
Collaborator Author

SamuelGuillemet commented Sep 12, 2022 •
edited
Loading

Schéma de la BDD :

Treasury
treasury_id PK
total_amount
cash_amount
transaction_id FK
Transaction
transaction_id PK
acount_id FK
transaction_datetime
amount
payment_method
item_id FK
Account
acount_id PK
username
password
roles
is_active
last_name
first_name
promotion_year
staff_name
is_inducted
Interface Item
item_id PK
item_name
type_id FK
amount

Types :

Type Fut
fut_id PK
price
is_mounted
Type Verre
verre_id PK
price
fut_id FK
Type Consommable
consommable_id PK
price

@SamuelGuillemet
Copy link
Collaborator Author

Planning aussi ?

@SamuelGuillemet

This comment was marked as outdated.

Sign in to view
@SamuelGuillemet SamuelGuillemet changed the title Créer le cahier des charges Créer le schéma de la base de données Sep 15, 2022
@SamuelGuillemet
Copy link
Collaborator Author

SamuelGuillemet commented Oct 18, 2022 •
edited
Loading

clochette (1)

xanode added a commit that referenced this issue Oct 25, 2022
@xanode
Improve out_of_stock_item SQLAlchemy model compliance #3
502b7ae
@SamuelGuillemet SamuelGuillemet pinned this issue Nov 12, 2022
@xanode xanode mentioned this issue Nov 14, 2022
Closed
8 tasks
@xanode xanode unpinned this issue Nov 18, 2022
@xanode xanode mentioned this issue Dec 3, 2022
Closed
@xanode
Copy link
Collaborator

xanode commented Mar 5, 2023

On est bon non ? On ferme l'issue ?

@SamuelGuillemet
Copy link
Collaborator Author

Il faut que j'update le schéma au final, t'as pas un moyen de faire un export à partir du code Python ?

@xanode
Copy link
Collaborator

xanode commented Mar 5, 2023

Je vais regarder. D'ailleurs on a pas utilisé la table stock il me semble.

@SamuelGuillemet SamuelGuillemet added the documentation Improvements or additions to documentation label Mar 17, 2023
@SamuelGuillemet SamuelGuillemet pinned this issue Mar 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@SamuelGuillemet SamuelGuillemet

@xanode xanode

Labels
documentation Improvements or additions to documentation enhancement New feature or request
Projects
Clochette
Status: ✅ Done
Milestone
HORS VERSION
Development

No branches or pull requests
2 participants
@SamuelGuillemet @xanode