db - postgresql.sql

来自「? 图片算不 # 图片算不 ! 图片算不 @ 图片算不」· SQL 代码 · 共 36 行

DROP TABLE Item;
DROP TABLE Report;
DROP TABLE NextID;

CREATE TABLE Report (
  ID             INT PRIMARY KEY,
  RVersion       VARCHAR(255),
  RHost          VARCHAR(255),
  RHostComment   VARCHAR(255),
  RUser          VARCHAR(255),
  RLocation      VARCHAR(255),
  RDateTime      VARCHAR(16),
  RComplete      SMALLINT
);

CREATE TABLE Item (
  INum           INT,
  IPage          VARCHAR(100),
  IDevice        VARCHAR(255),
  IGroup         VARCHAR(255),
  IField         VARCHAR(255),
  IValue         VARCHAR(255),
  IIcon          INT,
  IID            INT,
  ReportID       INT NOT NULL,
	
  CONSTRAINT     cnstI1 FOREIGN KEY(ReportID) REFERENCES Report(ID)
);

CREATE TABLE NextID (
  TableName      VARCHAR(6) PRIMARY KEY,
  NextID         INT NOT NULL
);

INSERT INTO NextID (TableName, NextID) VALUES ('Report', 1);