uptimeMart mockup

upmart.sql

-- A server has multiple responses
CREATE TABLE severs
(
  id serial NOT NULL, 
  url character varying(255)
);

--Each response belongs to one and only one server
CREATE TABLE responses
(
  id serial NOT NULL,
  -- Let's leave response time off for now
  successful boolean NOT NULL
  server_id integer
  created_at timestamp without time zone NOT NULL, #When was this response initiated?
  CONSTRAINT responses_pkey PRIMARY KEY (id )
)