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