Create Table

create table if not exists Vendor
(
	Name TEXT NOT NULL UNIQUE,
	Timestamp TEXT NOT NULL,
	Employees INTEGER NOT NULL,
	Sales REAL NOT NULL,
	Type TEXT NOT NULL
);

 

'Vender' 테이블 생성

컬럼 이름	데이터 타입	속성
Name	TEXT	NOT NULL UNIQUE
Timestamp	TEXT	NOT NULL
Employees	INTEGER	NOT NULL
Sales	REAL	NOT NULL
Type	TEXT	NOT NULL