Byte Dash

A restaurant food delivery service database implemented with drizzle.

Drizzle Kit Updates

drizzle-kit version 0.21 (released after the YouTube video referencing this repo was published) changed the options in the drizzle.config.ts file. This repo has been updated to reflect the changes. See this issue for more details.

View the dbdocs diagram here.

erDiagram
    address {
        Int id PK  "autoincrement()"
        String street_address_1
        String street_address_2  "nullable"
        String zip_code
        String delivery_instructions  "nullable"
        Int user_id FK
        Int city_id FK
        DateTime created_at  "now()"
        DateTime updated_at  "now()"
    }
    category {
        Int id PK  "autoincrement()"
        String name
    }
    city {
        Int id PK  "autoincrement()"
        String name
        Int state_id FK
    }
    comment {
        Int id PK  "autoincrement()"
        Int order_id FK
        Int user_id FK
        String comment_text
        Boolean is_complaint
        Boolean is_praise
        DateTime created_at  "now()"
        DateTime updated_at  "now()"
    }
    driver {
        Int id PK  "autoincrement()"
        String car_make
        String car_model
        Int car_year
        Int user_id FK
        Boolean online
        Boolean delivering
        DateTime created_at  "now()"
        DateTime updated_at  "now()"
    }
    menu_item {
        Int id PK  "autoincrement()"
        String name
        Int restaurant_id FK
        Int category_id FK
        String description
        String ingredients
        Decimal price
        Boolean active
        DateTime created_at  "now()"
        DateTime updated_at  "now()"
    }
    order_menu_item {
        Int id PK  "autoincrement()"
        Int order_id FK
        Int menu_item_id FK
        Int quantity
        Decimal item_price
        Decimal price
        String comment  "nullable"
    }
    order_status {
        Int id PK  "autoincrement()"
        Int order_id FK
        Int status_catalog_id FK
        DateTime created_at  "now()"
    }
    orders {
        Int id PK  "autoincrement()"
        Int restaurant_id FK
        DateTime estimated_delivery_time
        DateTime actual_delivery_time  "nullable"
        Int delivery_address_id FK
        Int user_id FK
        Int driver_id FK  "nullable"
        Decimal price
        Decimal discount
        Decimal final_price
        String comment  "nullable"
        DateTime created_at  "now()"
        DateTime updated_at  "now()"
    }
    restaurant {
        Int id PK  "autoincrement()"
        String name
        String street_address
        String zip_code
        Int city_id FK
        DateTime created_at  "now()"
        DateTime updated_at  "now()"
    }
    state {
        Int id PK  "autoincrement()"
        String name
        String code
    }
    status_catalog {
        Int id PK  "autoincrement()"
        String name
    }
    users {
        Int id PK  "autoincrement()"
        String name
        String contact_phone
        Boolean phone_verified
        String email
        Boolean email_verified
        String confirmation_code  "nullable"
        String password
        DateTime created_at  "now()"
        DateTime updated_at  "now()"
    }
    restaurant_owner {
        Int id PK  "autoincrement()"
        Int restaurant_id FK
        Int owner_id FK
    }
    address }o--|| city : city
    address }o--|| users : users
    city }o--|| state : state
    comment }o--|| orders : orders
    comment }o--|| users : users
    driver }o--|| users : users
    menu_item }o--|| category : category
    menu_item }o--|| restaurant : restaurant
    order_menu_item }o--|| menu_item : menu_item
    order_menu_item }o--|| orders : orders
    order_status }o--|| orders : orders
    order_status }o--|| status_catalog : status_catalog
    orders }o--|| address : address
    orders }o--|| driver : driver
    orders }o--|| restaurant : restaurant
    orders }o--|| users : users
    restaurant }o--|| city : city
    restaurant_owner }o--|| users : users
    restaurant_owner }o--|| restaurant : restaurant

Getting Started

Create .env file

Copy the .env.sample file and update the values accordingly. If you are using docker compose you can leave the values as is.

cp .env.sample .env

Start A PostgreSQL Database with Docker Compose

docker compose up

Migrate the DB

npm run db:migrate

Seed the DB

npm run db:seed

Start the Example API

npm run dev:api

Run the API Client

npm run dev:client