PostgreSQL 분석 함수 실습 테이블 만들기

실습준비 1

 

PRODUCT_GROUP 테이블 생성

CREATE TABLE PRODUCT_GROUP (
	GROUP_ID SERIAL PRIMARY key, 
	GROUP_NAME VARCHAR (255) NOT NULL
)

PRODUCT_GROUP 데이터 저장

 

INSERT
	INTO
	PRODUCT_GROUP (GROUP_NAME)
VALUES ('SMARTPHONE'),
('LAPTOP'),
('TABLET')

commit;

 

PRODUCT 테이블 만들기

CREATE TABLE PRODUCT (
	PRODUCT_ID SERIAL PRIMARY KEY,
	PRODUCT_NAME VARCHAR(255) NOT NULL,
	PRICE DECIMAL (11,2),
	GROUP_ID INT NOT NULL,
	FOREIGN KEY(GROUP_ID)
	REFERENCES PRODUCT_GROUP (GROUP_ID)
)

PRODUCT 데이터 저장

INSERT INTO PRODUCT (PRODUCT_NAME, GROUP_ID,PRICE)
VALUES 
('Microsoft Lumia',1,200),
('HTC One',1,400),
('Nexus',1,500),
('iPhone',1,900),
('HP Elite',2,1200),
('Lenovo Thinkpad',2,700),
('Sony VAIO',2,700),
('Dell Vostro',2,800),
('iPad',3,700),
('Kindle Fire',3,150),
('Samsung Galaxy Tab',3,200);

commit;