# data[].attributes.attachment_link.title
정규화 및 무결성 제약

# data[].attributes.attachment_link.readable_text
CREATE TABLE TableA (
    product_id INT PRIMARY KEY,
    product_name VARCHAR(20) NOT NULL
);
CREATE TABLE TableB (
    product_id INT,
    stock_qty INT,
    FOREIGN KEY (product_id) REFERENCES TableA(product_id)
);
INSERT INTO TableA (product_id, product_name)
VALUES
    (1, 'a'),
    (2, 'b'),
    (3, 'c'),
    (4, 'd'),
    (5, 'e');
INSERT INTO TableB (product_id, stock_qty)
VALUES
    (1, 100),
    (3, 200),
    (4, 300);

# data[].attributes.attachment_link.readable_text
CREATE TABLE product (
    product_id INT PRIMARY KEY,
    product_name VARCHAR(50),
    price INT
);
INSERT INTO product (product_id, product_name, price)
VALUES
(1, 'Keyboard', 30000),
(2, 'Mouse', 15000),
(3, 'Monitor', 200000),
(4, 'Webcam', 50000);

CREATE TABLE orders (
    order_id INT PRIMARY KEY,
    product_id INT,
    quantity INT,
    FOREIGN KEY (product_id) REFERENCES product(product_id)
);
INSERT INTO orders (order_id, product_id, quantity)
VALUES
(101, 1, 2),
(102, 3, 1),
(103, 1, 1),
(104, 5, 4); 

# data[].attributes.headline
데이터 베이스 실전 문제

# data[].attributes.subject
데이터 베이스 실전 문제

# data[].attributes.body
INSERT INTO album VALUES

(101, 1, 'X', 500000),

(102, 2, 'Whole Lotta Red', 900000),

(103, 3, 'Virgo World', 300000),

(104, 4, 'Dying to Live', 600000);

# data[].attributes.headline
데이터베이스 프로젝트 수행

# data[].attributes.subject
데이터베이스 프로젝트 수행

# data[].attributes.attachment_link.title
데이터베이스 프로젝트(1학년)

# data[].attributes.headline
윈도우 함수 계층령 쿼리

# data[].attributes.subject
윈도우 함수 계층령 쿼리

# data[].attributes.attachment_link.title
제목을 입력해주세요.

# data[].attributes.attachment_link.title
뷰와 인덱스

# data[].attributes.attachment_link.title
제목을-입력해주세요__복사본

# data[].attributes.attachment_link.title
제목을 입력해주세요.- 복사본

# data[].attributes.attachment_link.title
제목을-입력해주세요__복사본