목록starbuckDB (1)

새벽코딩

[PostgresDB-2] 10. Relationship (별다방 카페 실습)

참고 : https://cloudstudying.kr/lectures/509 테이블생성 및 데이터 DB 쿼리 CREATE TABLE orders( id SERIAL PRIMARY KEY, --PK status VARCHAR(50), created_at TIMESTAMPTZ ); CREATE TABLE beverages( id SERIAL PRIMARY KEY, name VARCHAR(50), price INTEGER, btype VARCHAR(50) ); CREATE TABLE order_details( id SERIAL PRIMARY KEY, order_id INTEGER REFERENCES orders(id), beverage_id INTEGER REFERENCES beverages(id), coun..
Programming/Postgres DB 2022. 12. 21. 06:29
이전 Prev 1 Next 다음