OpenRoadmaps
Tables (8)
Client (client)
- id (client_id) — Long — Primary key — NOT NULL
- name — String
- email — String
- password — String
- isEmailVerified — boolean
- googleOAuthId — String
- githubOAuthId — String
- picture — String
- role — Role
- isEnabled — boolean
- create_date — DATE
- update_date — DATE
Post (post)
- id (post_id) — Long — Primary key — NOT NULL
- title — String
- content — String
- access — AccessType
- password — String
- client (client_id) — Long — Foreign key → Client.id — NOT NULL
- roadmapItem (roadmap_item_id) — Long — Foreign key → RoadmapItem.id — NOT NULL
PostLike (post_like)
- client (client_id) — Long — Foreign key → Client.id — NOT NULL
- post (post_id) — Long — Foreign key → Post.id — NOT NULL
- created_date — DATE
Roadmap (roadmap)
- id (roadmap_id) — Long — Primary key — NOT NULL
- title — String
- image — String
- accessibility — Accessibility
- likes — int
- isOfficial — boolean
- isDeleted — boolean
- client (client_id) — Long — Foreign key → Client.id — NOT NULL
- created_date — DATE
- updated_date — DATE
RoadmapItem (roadmap_item)
- id (roadmap_item_id) — Long — Primary key — NOT NULL
- name — String
- content — Text
- x — double
- y — double
- recommend — Recommend
- connectionType — Connection
- parent (parent_id) — Long — Foreign key → RoadmapItem.id — NOT NULL
- roadmap (roadmap_id) — Long — Foreign key → Roadmap.id — NOT NULL
- created_date — DATE
- updated_date — DATE
RoadmapItemClear (roadmap_item_clear)
- id (roadmap_item_clear_id) — Long — Primary key — NOT NULL
- created_date — DATE
- clear — boolean
- clientId (client_id) — Long — Foreign key → Client.id — NOT NULL
- roadmapItemId (roadmap_item_id) — Long — Foreign key → RoadmapItem.id — NOT NULL
RoadmapItemReference (roadmap_item_reference)
- id (roadmap_item_reference_id) — Long — Primary key — NOT NULL
- url — String
- created_date — DATE
- updated_date — DATE
- roadmapItem (roadmap_item_id) — Long — Foreign key → RoadmapItem.id — NOT NULL
RoadmapLike (roadmap_like)
- id (roadmap_like_id) — Long — Primary key — NOT NULL
- like — boolean
- created_date — DATE
- clientId (client_id) — Long — Foreign key → Client.id — NOT NULL
- roadmapId (roadmap_id) — Long — Foreign key → Roadmap.id — NOT NULL