从0到1：琴房预订小程序开发笔记（上）

背景调研

解决琴房难找，日程时间难协调等痛点，提升效率降低组织成本。可以查询某个时间段的空闲琴房，查询某个琴房的空闲时间段；琴房状态一目了然，完美解决琴房时间冲突和空间浪费问题。前后端完整代码，包括选择琴房，修改日期、时间，以及备注进行琴房创建。预约成功后，可以查看预约详情

概要设计

数据库设计

EnrollJoinModel.DB_STRUCTURE = {
	_pid: 'string|true',
	ENROLL_JOIN_ID: 'string|true',
	ENROLL_JOIN_ENROLL_ID: 'string|true|comment=报名PK',

	ENROLL_JOIN_IS_ADMIN: 'int|true|default=0|comment=是否管理员添加 0/1',

	ENROLL_JOIN_ENROLL_NAME: 'string|false',

	ENROLL_JOIN_DAY: 'string|false|comment=预约日期',
	ENROLL_JOIN_START: 'string|false|comment=开始时间',
	ENROLL_JOIN_END: 'string|false|comment=结束时间',
	ENROLL_JOIN_END_POINT: 'string|false|comment=结束时间末尾',

	ENROLL_JOIN_USER_ID: 'string|true|comment=用户ID', 
	ENROLL_JOIN_FORMS: 'array|true|default=[]|comment=表单',
	ENROLL_JOIN_OBJ: 'object|true|default={}',

	ENROLL_JOIN_STATUS: 'int|true|default=1|comment=状态 0=待审核 1=报名成功, 99=审核未过',
	ENROLL_JOIN_REASON: 'string|false|comment=审核拒绝或者取消理由',

	ENROLL_JOIN_LAST_TIME: 'int|true|default=0', 
	
	ENROLL_JOIN_ADD_TIME: 'int|true',
	ENROLL_JOIN_EDIT_TIME: 'int|true',
	ENROLL_JOIN_ADD_IP: 'string|false',
	ENROLL_JOIN_EDIT_IP: 'string|false',
};

EnrollModel.DB_STRUCTURE = {
	_pid: 'string|true',
	ENROLL_ID: 'string|true',

	ENROLL_TITLE: 'string|true|comment=标题',
	ENROLL_STATUS: 'int|true|default=1|comment=状态 0=未启用,1=使用中',

	ENROLL_CATE_ID: 'string|true|default=0|comment=分类',
	ENROLL_CATE_NAME: 'string|false|comment=分类冗余',

	ENROLL_CANCEL_SET: 'int|true|default=1|comment=取消设置 0=不允,1=允许,2=仅截止前可取消,3=审核后不可取消',
	ENROLL_EDIT_SET: 'int|true|default=1|comment=修改 0=不允,1=允许,2=仅截止前可,3=审核后不可修改',
	ENROLL_CHECK_SET: 'int|true|default=0|comment=审核 0=不需要审核,1=需要审核',

 

	ENROLL_ORDER: 'int|true|default=9999',
	ENROLL_VOUCH: 'int|true|default=0',

	ENROLL_FORMS: 'array|true|default=[]',
	ENROLL_OBJ: 'object|true|default={}',

	ENROLL_JOIN_FORMS: 'array|true|default=[]',

	ENROLL_QR: 'string|false',
	ENROLL_VIEW_CNT: 'int|true|default=0',
	ENROLL_JOIN_CNT: 'int|true|default=0',

	ENROLL_ADD_TIME: 'int|true',
	ENROLL_EDIT_TIME: 'int|true',
	ENROLL_ADD_IP: 'string|false',
	ENROLL_EDIT_IP: 'string|false',
};