- SQLite as a SQL database engine.
- SVG entity-relationship model made in Inkscape.
- Diagram of database schema made in WWW SQL Designer.
- DB Browser as a database management system.
- POWER RESERVE isn't supported yet. ✔
- The Crown relation named
may_have_a_crownis still unfilled for every watch in the DB. ✔ - Instructions to solve using SQL (10). ✔
- The watch complication relation named
may_have_a_complication. ✔ - Bezel support. ✔
- Build a REST API in ExpressJS that can support CRUD functions. ❌
- Build a frontend and render all the information. ❌
These are the main tables in the DB: Case, Basic_info, Movement, Dial, Caseback, and Band.
| Case | Data Type |
|---|---|
id_case |
Integer |
id_crystal |
Integer |
id_material |
Integer |
id_color |
Integer |
id_pusher |
Integer |
id_shape |
Integer |
diameter |
Float |
thickness |
Float |
lug_width |
Float |
lug_to_lug |
Float |
id_movement |
Integer |
id_caseback |
Integer |
id_dial |
Integer |
id_band |
Integer |
| Basic_info | Data Type |
|---|---|
id_watch |
Integer |
model |
String |
id_manufactured_in |
Integer |
id_brand |
Integer |
id_style |
Integer |
id_gender |
Integer |
water_resistance |
Integer |
weight |
Float |
| Movement | Data Type |
|---|---|
id_movement |
Integer |
id_movement_type |
Integer |
id_battery |
Integer |
battery_life |
Integer |
power_reserve |
Integer |
| Dial | Data Type |
|---|---|
id_dial |
Integer |
id_dial_type |
Integer |
id_index |
Integer |
id_hand |
Integer |
id_color |
Integer |
luminance |
Boolean |
| Caseback | Data Type |
|---|---|
id_caseback |
Integer |
id_shape |
Integer |
id_caseback_design |
Integer |
id_material |
Integer |
| Band | Data Type |
|---|---|
id_band |
Integer |
id_band_type |
Integer |
id_clasp |
Integer |
id_material |
Integer |
id_color |
Integer |