소개
게시글
질문&답변
2024.02.15
Connection & Table 생성 강의에서 사용하는 쿼리 출처
CREATE TABLE coffee_menu ( no number GENERATED AS IDENTITY , coffee VARCHAR2(100) NOT NULL , kind VARCHAR2(100) NOT NULL , price number(11) DEFAULT 0 NOT NULL, reg_day date DEFAULT sysdate NOT NULL , mod_day date DEFAULT sysdate NOT NULL , CONSTRAINT pk_coffee_menu PRIMARY KEY(no) ) ; COMMENT ON TABLE coffee_menu IS '커피/음료 메뉴'; ----------------------------------------------------- CREATE TABLE cust_info ( no number GENERATED AS IDENTITY , cust_id VARCHAR2(100) NOT NULL, name VARCHAR2(100) NOT NULL, email VARCHAR2(100) NOT NULL, role VARCHAR2(100) DEFAULT 'MEMBER' NOT NULL , reg_day date default sysdate NOT NULL, CONSTRAINT pk_cust_info PRIMARY KEY(no) ); COMMENT ON TABLE cust_info IS '고객정보'; -- unique index 생성 ALTER TABLE cust_info ADD CONSTRAINT idx_cust_info UNIQUE(cust_id); ----------------------------------------------------- CREATE TABLE order_list ( no number GENERATED AS IDENTITY , coffee_no number(11) NOT NULL, coffee VARCHAR2(100) NOT NULL, price number(11) NOT NULL, cust_id VARCHAR2(100) NOT NULL, name VARCHAR2(100) NOT NULL, reg_day date default sysdate , CONSTRAINT pk_order_list PRIMARY KEY(no) ); COMMENT ON TABLE order_list IS '주문내역'; -- foreign key 생성 ALTER TABLE order_list ADD CONSTRAINT fk_coffee_no FOREIGN KEY (coffee_no) REFERENCES coffee_menu(no); ALTER TABLE order_list ADD CONSTRAINT fk_cust_id FOREIGN KEY (cust_id) REFERENCES cust_info(cust_id);
- 1
- 3
- 298
질문&답변
2023.12.07
Section3_01. 두 배열 합치기에서 런타임 에러 미해결
첫번째 배열보다 두번째 배열이 먼저 끝나는 경우를 생각해보세여 !p2==M이 되고if (p1 ex. 이 예시로 한번 생각해보세욥101 10 27 39 50 61 65 70 93 93 77 51 65 66 70 82 92
- 0
- 1
- 244
질문&답변
2023.04.10
9분 05초 author이랑 isbn
감사합니다 ! 덕분에 이해했습니닷 !
- 0
- 2
- 442