Database schema

Jump to bottom

Tan Yuanhong edited this page Jun 10, 2019 · 2 revisions

Tables

File: file_table
Module: module_table

Schema

CREATE TABLE file_table (
  uuid TEXT PRIMARY KEY,
  parent_id TEXT NOT NULL,
  is_file BOOLEAN NOT NULL,
  file_location TEXT,
  last_updated TEXT,
  name TEXT NOT NULL,
  json TEXT NOT NULL
)

CREATE TABLE module_table (
  uuid TEXT PRIMARY KEY,
  name TEXT NOT NULL,
  course_name TEXT NOT NULL,
  json TEXT NOT NULL
)