Contents

BLOG_SCHEMA = {
  tables: {
    users: [
      { name: :id, type: String, options: { primary_key: true } },
      { name: :first_name, type: String },
      { name: :last_name, type: String },
      { name: :email, type: String },
    ],
    posts: [
      { name: :id, type: String, options: { primary_key: true } },
      { name: :subject, type: String },
      { name: :body, type: String },
      { name: :author_id, type: String},
      { name: :created_at, type: DateTime },
      { name: :updated_at, type: DateTime },
    ],
    comments: [
      { name: :id, type: String, options: { primary_key: true } },
      { name: :body, type: String },
      { name: :post_id, type: String },
      { name: :commenter_id, type: String },
    ],
    categories: [
      { name: :id, type: String, options: { primary_key: true } },
      { name: :name, type: String },
    ],
    categories_to_posts: [
      { name: :post_id, type: String, options: { null: false } },
      { name: :category_id, type: String, options: { null: false } },
    ],
  },
  unique_indexes: [
    # [:categories_to_posts, :post_id, :category_id]
  ],
  foreign_keys: [
    [:posts, :author_id, :users, :id],
    [:comments, :post_id, :posts, :id],
    [:comments, :commenter_id, :users, :id],
    [:categories_to_posts, :post_id, :posts, :id, on_delete: :cascade],
    [:categories_to_posts, :category_id, :categories, :id],
  ]
}

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
terrestrial-0.5.0	spec/support/blog_schema.rb