7 lines
497 B
SQL
Executable File
7 lines
497 B
SQL
Executable File
-- ============================================
|
|
-- 此文件由 Meoo Cloud 自动生成，请勿修改
|
|
-- This file is auto-generated by Meoo Cloud, DO NOT MODIFY
|
|
-- ============================================
|
|
|
|
CREATE TABLE collection_stocks (id SERIAL PRIMARY KEY, collection_id INTEGER NOT NULL REFERENCES stock_collections(id) ON DELETE CASCADE, stock_code VARCHAR(10) NOT NULL, stock_name VARCHAR(50) NOT NULL, added_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), UNIQUE(collection_id, stock_code));
|