| -- Copyright 2021 The Go Authors. All rights reserved. |
| -- Use of this source code is governed by a BSD-style |
| -- license that can be found in the LICENSE file. |
| |
| BEGIN; |
| |
| CREATE TABLE documentation_symbols ( |
| id INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, |
| documentation_id INTEGER NOT NULL, |
| package_symbol_id INTEGER NOT NULL, |
| |
| UNIQUE(documentation_id, package_symbol_id), |
| -- TODO: add FK to documentation.id in a future migration, once the UNIQUE |
| -- constraint has been added. |
| FOREIGN KEY (package_symbol_id) REFERENCES package_symbols(id) ON DELETE CASCADE |
| ); |
| COMMENT ON TABLE documentation_symbols IS |
| 'TABLE documentation_symbols contains symbols for a given row in the documentation table.'; |
| |
| END; |
