mint/api-v8/public/documents/api/course.md

Course 课程

Table

CREATE TABLE courses
(
    id SERIAL PRIMARY KEY,
    uuid VARCHAR(36),	
    cover VARCHAR(255),
    title VARCHAR(32) NOT NULL,
    subtitle VARCHAR(32),
    summary VARCHAR(255),
    teacher_id INTEGER NOT NULL,
    lang VARCHAR (8),
    speech_lang VARCHAR (8),
    status INTEGER NOT NULL DEFAULT(10),
    lesson_num INTEGER NOT NULL DEFAULT(0),
    content TEXT ,
    creator_id INTEGER NOT NULL,
    version INTEGER DEFAULT(1),
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE lessons
(
    id SERIAL PRIMARY KEY,
    uuid VARCHAR(36),	
    course_id INTEGER NOT NULL,
    course_uuid VARCHAR(36),
    cover VARCHAR(255),	
    title VARCHAR(32) NOT NULL,
    subtitle VARCHAR(32),
    summary VARCHAR(255),
    status INTEGER  NOT NULL DEFAULT(10),
    teacher_id INTEGER,
    lang VARCHAR(8),
    speech_lang VARCHAR(8),
    start_datetime TIMESTAMP,
    duration INTEGER,
    content TEXT,
    creator_id INTEGER  NOT NULL,
    version INTEGER DEFAULT(1),
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

API

GET /api/course/:cid PUT /api/course/?data=data POST /api/course/:cid/?data=data DELETE /api/course/:cid

GET /api/lesson/:lid GET /api/lessons/:cid PUT /api/lesson/?data=data POST /api/lesson/:lid/?data=data DELETE /api/lesson/:lid