Datenbanken im Umfeld verteilter Systeme

tickets=# CREATE TABLE tickets (
  id SERIAL PRIMARY KEY,
  title TEXT NOT NULL,
  status TEXT NOT NULL
);

CREATE TABLE comments (
  id SERIAL PRIMARY KEY,
  ticket_id INT NOT NULL REFERENCES tickets(id) ON DELETE CASCADE,
  body TEXT NOT NULL
);
CREATE TABLE
CREATE TABLE

test> db.tickets.insertOne({
|   title: "Login schlägt fehl",
|   status: "open",
|   comments: [ { body: "Tritt nur mit SSO auf", author: "anna" } ]
| })
{
  acknowledged: true,
  insertedId: ObjectId('6abf54410639470122c3e003')
}