2022-06-04

AzureBackup備忘

・別リージョンにはバックアップリストアできない

・GRSがデフォルト

・複製先のペアリージョンは決まってる

・セカンダリ側のRPOは36時間

・セカンダリでの復元には、セカンダリ側にもストレージアカウントが必要

2020-11-02

Index作るSQL

gihyo.jp

↑の5章の最後でIndex作るSQL

***

create table order_app.tbl_customer
(
customer_no number(4) not null,
customer_name varchar2(40 char) not null,
customer_address varchar2(200 char) not null,
constraint pk_customer_no primary key (customer_no)
)
tablespace order_tbs
;

create table order_app.tbl_product
(
product_no char(6) not null,
product_name varchar2(40 char) not null,
price number(10) not null check (price > 0),
constraint pk_product_no primary key (product_no),
constraint uq_product_name unique (product_name)
)
tablespace order_tbs
;

create table order_app.tbl_order
(
order_no number(4) not null,
order_date date not null,
pay_type varchar2(10 char) not null check (pay_type in ('現金払い','銀行振込')),
customer_no number(4) not null,
constraint pk_order_no primary key (order_no),
constraint fk_order_customer_no foreign key (customer_no)
references order_app.tbl_customer (customer_no)
)
tablespace order_tbs
;

create table order_app.tbl_order_item
(
order_no number(4) not null,
order_item_no number(5) not null,
product_no char(6) not null,
order_num number(10) not null check (order_num > 0),
item_account number(10) not null check (item_account > 0),
constraint pk_order_item_no primary key (order_no, order_item_no),
constraint fk_order_item_order_no foreign key (order_no)
references order_app.tbl_order (order_no),
constraint fk_order_item_product_no foreign key (product_no)
references order_app.tbl_product (product_no)
)
tablespace order_tbs
;