flask Architecture Docs
Home / File/ schema.sql — flask Source File

schema.sql — flask Source File

Architecture documentation for schema.sql, a sql file in the flask codebase.

File sql 2 classes

Entity Profile

Relationship Graph

Source Code

-- Initialize the database.
-- Drop any existing data and create empty tables.

DROP TABLE IF EXISTS user;
DROP TABLE IF EXISTS post;

CREATE TABLE user (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  username TEXT UNIQUE NOT NULL,
  password TEXT NOT NULL
);

CREATE TABLE post (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  author_id INTEGER NOT NULL,
  created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  title TEXT NOT NULL,
  body TEXT NOT NULL,
  FOREIGN KEY (author_id) REFERENCES user (id)
);

Classes

Source

Frequently Asked Questions

What does schema.sql do?
schema.sql is a source file in the flask codebase, written in sql.
Where is schema.sql in the architecture?
schema.sql is located at examples/tutorial/flaskr/schema.sql (directory: examples/tutorial/flaskr).

Analyze Your Own Codebase

Get architecture documentation, dependency graphs, and domain analysis for your codebase in minutes.

Try Supermodel Free