staff

2 rows

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

staff_id ▼ first_name last_name address_id picture store_id active username password last_update
1 Mike Hillyer 3 3   1 1 1 Mike 8cb2237d0679ca88db6464eac60da96345513964 2020-12-23 07:12:31
2 Jon Stephens 4 4   2 2 1 Jon 8cb2237d0679ca88db6464eac60da96345513964 2020-12-23 07:12:31

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE staff (
  staff_id SMALLINT NOT NULL,
  first_name VARCHAR(45) NOT NULL,
  last_name VARCHAR(45) NOT NULL,
  address_id INT NOT NULL,
  picture BLOB DEFAULT NULL,
  email VARCHAR(50) DEFAULT NULL,
  store_id INT NOT NULL,
  active SMALLINT DEFAULT 1 NOT NULL,
  username VARCHAR(16) NOT NULL,
  password VARCHAR(40) DEFAULT NULL,
  last_update TIMESTAMP NOT NULL,
  PRIMARY KEY  (staff_id),
  CONSTRAINT fk_staff_store FOREIGN KEY (store_id) REFERENCES store (store_id) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT fk_staff_address FOREIGN KEY (address_id) REFERENCES address (address_id) ON DELETE NO ACTION ON UPDATE CASCADE
);
CREATE INDEX idx_fk_staff_store_id ON staff(store_id)
;
CREATE INDEX idx_fk_staff_address_id ON staff(address_id)
;