tags: tech

[返回](https://hackmd.io/hyNEFbouQbmF4ObBrJDrLg)
# data design

## 课程信息 Json

主键：课号

{
    Course Code (code)
    Department (org)
}

## 课程信息官方JSON：

{
    "MAT135H1-F-20199": {
        "courseId": "32311",
        "org": "MAT",
        "orgName": "Mathematics (MAT) (APM) (JMB) (JUM)",
        "courseTitle": "Calculus 1(A)",
        "code": "MAT135H1",
        "courseDescription": "Review of trigonometric functions, trigonometric identities and trigonometric limits. Functions, limits, continuity. Derivatives, rules of differentiation and implicit differentiation, related rates, higher derivatives, logarithms, exponentials. Trigonometric and inverse trigonometric functions, linear approximations. Mean value theorem, graphing, min-max problems, l\u2019H\u00f4pital\u2019s rule; anti- derivatives.  Examples from life science and physical science applications.",
        "prerequisite": "High school level calculus",
        "corequisite": "",
        "exclusion": "MAT133Y1, MAT136H1, MAT137Y1, MAT157Y1, MATA30H3, MATA31H3, MATA32H3, MATA33H3, MATA35H3, MATA36H3, MATA37H3,  MAT133Y5, MAT134Y5, MAT135Y5, MAT137Y5, MAT138Y5, MAT186H, MAT187H, MAT194H, MAT195H, MAT196H &  MAT197H",
        "recommendedPreparation": "",
        "section": "F",
        "session": "20199",
        "webTimetableInstructions": "",
        "breadthCategories": "The Physical and Mathematical Universes (5)",
        "distributionCategories": "Science",
        },
        "meetings":{}
}

## 账户信息

{
    "email":"a.a",
    "username":"AA",
    "password":"123456",
    //账户信息可并入用户信息，内容存在重叠
}

## 用户信息
主键：用户编号

{
    "username": "用户名",
    "UTemail": "UT邮箱",
    "password":"用户密码",
    "avatar": "头像",
    "campus": "校区",
    "description": "简介",
    "courses": ["课程编号1", "课程编号2"],
    "weixin": "微信号",
    "phone": "手机号",
    "facebook": "账号",
    "qq": "账号"
}

## 帖子信息
主键：帖子编号

{
    "category":"所属板块",
    "publisher": "发帖人ID",
    "type": "找课友/找队友(找课友0,找队友1)",
    "courseid":"课号",
    "sectionid":"课程号",
    "content": "帖子内容",
    "time": "帖子发布的时间(yyyy-mm-dd hh:mm:ss utc)",
    "activate-time":"帖子激活时间(yyyy-mm-dd hh:mm:ss utc)",
    "privacy":"(true:有隐私,false:无隐私)",
    "status": "发布状态(草稿0,发布1,失效2)",
    "Attended": ["参与人1ID","参与人2ID"],
    "Requested":["请求者1ID":{
        "Message":"详细请求描述"
    }
    ,"请求者2ID":{
        "Message":"详细请求描述"
    }
    ]
}