Database model

[michalhosna]

Create database model based upon our discussion.

[michalhosna]

Probably good next steps would be to write doctrine entities.

I will provide sample soon.

For ID i would use UUID. For Doctrine mapping anotations.

Doctrine docs:

• Basic mapping
• Association mapping
• Anontations

  PHPstorm

  In phpstorm there are getter/setter generator and doctrine annotation generator wich can really ease up this work.

Money.

We have to resolve how to store prices.

One approch is to have global "basic currency", and in DB prices are stored as price*100 in basic currency (int)

Files

We have to resolve how to store files.

Probably some filesystem abstraction would be ideal. (So we could also use Object storage)

[michalhosna]

Example entity: https://github.com/AVCSH/savec/pull/10/commits/20ea89e07c6460bda99639f16865d21e1633e887

Notes:

• ItemType, Type is not a keyword, this entity is for "Type of item" so ItemType is full name.

• Before submiting entity try to run

  bin/console doctrine:mapping:info

[michalhosna]

Also see:

• Wiki - Technika(CS)
• Airtable, where should be some data entered soon.