coursera-glossary/course_branches.html at master · GatechVIP/coursera-glossary · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
<head>
<style>

    div {
        font-family: monospace;
    }

    table, th, td {
        border: 1px solid black;
        border-collapse: collapse;
    }

    tr:nth-child(odd) {
        background-color: #FFFFFF;
    }
    tr:nth-child(even) {
        background-color: #EBF2F2;
    }

    th, td {
        text-align: left;
        padding: 5px 10px 5px 5px;
    }

</style>
</head>


<div>
    <h1>course_branches</h1>

    <h2>Description</h2>
    <p>
        A course has many branches. Each branch contains separate course materials. Course authors create branches to make large changes to course materials that would break the learner experience if they happened in-place.
    </p>

    <h2> Columns </h2>
    <table>
        <tr><th>Name</th><th>Description</th></tr>

        <tr>
          <td>course_branch_id</td><td>The id of this branch.</td>
        </tr>

        <tr>
          <td>course_id</td><td>The course that this branch is in.</td>
        </tr>

        <tr>
          <td>course_branch_changes_description</td><td>A user-facing summary of the changes between this branch and the previous branch.</td>
        </tr>

    </table>

    <h2>SQL create statement</h2>
    <pre>
CREATE TABLE course_branches (
    course_branch_id VARCHAR(50)
    ,course_id VARCHAR(50)
    ,course_branch_changes_description VARCHAR(65535)
    ,PRIMARY KEY (course_branch_id)
    ,FOREIGN KEY (course_id) REFERENCES courses(course_id)
);
    </pre>
</div>