Skip to content

rubens-costa/myMoovies

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Estrutura do Projeto:

```
- src
    - controllers
        - MooviesController.js
        - CategoryController.js
    - routes
        - moovies.js
        - category.js
    - db
        - index.js
- index.js
- package.json
- package-lock.json
- .env
- .env.example
- .gitignore
- readme.md
```

Schema DB

CREATE TABLE category (
    id  SERIAL PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    description VARCHAR(255)
);
CREATE TABLE moovie (
    id SERIAL PRIMARY KEY,
    category_id INTEGER REFERENCES category(id) ON DELETE CASCADE,
    title VARCHAR(255) NOT NULL,
    description VARCHAR(255),
    realease_date VARCHAR(255)
);

Releases

No releases published

Packages

No packages published