PostgreSQL 模式——使用场景案例

使用PostgreSQL的模式在各种场景下都可以发挥重要的作用。无论是在企业级应用程序、数据仓库还是云计算环境中，PostgreSQL的模式都被广泛应用。本文将探讨一些常见的使用场景，并提供相应的案例代码。

sql
CREATE SCHEMA data_warehouse;
CREATE TABLE data_warehouse.customers (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL
);
CREATE TABLE data_warehouse.orders (
    id SERIAL PRIMARY KEY,
    customer_id INTEGER NOT NULL,
    product VARCHAR(100) NOT NULL,
    quantity INTEGER NOT NULL,
    FOREIGN KEY (customer_id) REFERENCES data_warehouse.customers (id)
);

sql
CREATE SCHEMA enterprise_app;
CREATE TABLE enterprise_app.users (
    id SERIAL PRIMARY KEY,
    username VARCHAR(100) NOT NULL,
    password VARCHAR(100) NOT NULL
);
CREATE TABLE enterprise_app.products (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    price DECIMAL(10, 2) NOT NULL
);
CREATE TABLE enterprise_app.orders (
    id SERIAL PRIMARY KEY,
    user_id INTEGER NOT NULL,
    product_id INTEGER NOT NULL,
    quantity INTEGER NOT NULL,
    FOREIGN KEY (user_id) REFERENCES enterprise_app.users (id),
    FOREIGN KEY (product_id) REFERENCES enterprise_app.products (id)
);

sql
CREATE SCHEMA tenant1;
CREATE SCHEMA tenant2;
CREATE TABLE tenant1.customers (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL
);
CREATE TABLE tenant2.customers (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    email VARCHAR(100) NOT NULL
);