--
-- MyJSQLView SQL Dump
-- Version: 3.23
-- WebSite: http://myjsqlview.org
--
-- Host: 127.0.0.1
-- Generated On: 2010.10.21 AD at 11:13:04 MDT
-- SQL version: PostgreSQL 9.0.1
-- Database: key_tables
--

-- ------------------------------------------

--
-- Table structure for table "public"."employee"
--

DROP DOMAIN IF EXISTS "salary_domain";
CREATE DOMAIN "salary_domain" AS numeric(12,2) NOT NULL CHECK (value > 0);

DROP TABLE IF EXISTS "public"."employee";
CREATE TABLE "public"."employee" (
    "id" serial NOT NULL,
    "salary" "salary_domain",
    PRIMARY KEY ("id")
);