java-explore-with-me

TEAM 1 PROJECT

Main DB structure

erDiagram
    categories {
        bigint id PK
        varchar(50) name
    }

    users {
        bigint id PK
        varchar(250) name
        varchar(254) email
    }

    locations {
        bigint id PK
        double lat
        double lon
    }

    events {
        bigint id PK
        varchar(2000) annotation
        bigint category_id FK
        bigint confirmed_requests
        timestamp created_on
        varchar(7000) description
        timestamp event_date
        bigint user_id FK
        bigint location_id FK
        boolean paid
        integer participant_limit
        timestamp published_on
        boolean request_moderation
        varchar(100) state
        varchar(120) title
        bigint views
    }

    requests {
        bigint id PK
        bigint requester_id FK
        bigint event_id FK
        timestamp created_on
        varchar(100) status
    }

    compilations {
        bigint id PK
        boolean pinned
        varchar(50) title
    }

    event_compilations {
        bigint event_id FK
        bigint compilation_id FK
    }

    comments {
        bigint id PK
        bigint event_id FK
        bigint author_id FK
        varchar(255) message
    }
    
    users ||--o{ events: user_id
    users ||--o{ requests: requester_id
    events ||--o{ requests: event_id
    events ||--o{ comments: event_id
    users ||--o{ comments: author_id
    events ||--o{ event_compilations: event_id
    compilations ||--o{ event_compilations: compilation_id
    categories ||--o{ events: category_id
    locations ||--o{ events: location_id

Loading

Stats DB structure

erDiagram
    test {
        bigint id PK
        varchar(100) app
        varchar(100) uri
        varchar(100) ip
        timestamp created_at
    }

Loading

Development agreements:

1. Mappers generated by MapStruct
2. Link ONE Service to Many Repositories
3. All Common contants located in stats-service/stats-common/src/main/java/ru/practicum/Contants.java
4. Stats DTO located in stats-service/stats-common/src/main/java/ru/practicum
5. Tests should be implemented JsonTest, ControllerTest, ServiceTest, IntegrationTest (On Queries)