一、新建數(shù)據(jù)庫

字符集：utf8 --UTF-8 Unicode
排序規(guī)則：utf8_general_ci
數(shù)據(jù)庫名：Haodf_DOC

二、新建項目：Django

pip install django==1.9

#windows系統(tǒng)用exe安裝
pip install mysql-python

三、Django app設(shè)計

xadmin——后臺管理平臺-操作數(shù)據(jù)中的醫(yī)生數(shù)據(jù)
用戶做權(quán)限限制，不可刪除

四、配置model

/settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'doc',
        'USER':'***',
        'PASSWORD':'*******',
        'HOST':'127.0.0.1'
    }
}

執(zhí)行數(shù)據(jù)遷移
manage.py@_admin >makemigrations
manage.py@_admin >migrate

五、數(shù)據(jù)庫設(shè)計

省份表

表名：省份
字段：省份id，省份名

地區(qū)表

表名：地區(qū)
字段：地區(qū)id，地區(qū)名，省份id

醫(yī)院表

表名：醫(yī)院
字段：醫(yī)院id，醫(yī)院名，醫(yī)院等級，醫(yī)院類型，地區(qū)id，

科室表

表名：科室
字段：科室id，科室名，醫(yī)院id，

醫(yī)生表

表名：醫(yī)生
字段：醫(yī)生id，醫(yī)生姓名，科室id，職稱，擅長，執(zhí)業(yè)經(jīng)歷，感謝信數(shù)量，禮物數(shù)量，活躍熱度，幫助患者數(shù)

六、建立app

新建app
manage.py@_admin > startapp doc

_建立model____/admin/models.py

# _*_ encoding:utf-8 _*_
from __future__ import unicode_literals

from django.db import models
from datetime import datetime
# Create your models here.

省份model

class Province(models.Model):
        pro = models.CharField(max_length=50,verbose_name=u'省份')

    class Meta:
        verbose_name = u'省份'
        verbose_name_plural = verbose_name

地區(qū)model

class Area(models.Model):
    pro = models.ForeignKey(Province,verbose_name=u'省份')
    area = models.CharField(max_length=50,verbose_name=u'地區(qū)')

    class Meta:
        verbose_name = u'地區(qū)'
        verbose_name_plural = verbose_name

醫(yī)院model

class Hospital(models.Model):
    area = models.ForeignKey(Area,verbose_name=u'地區(qū)')
    hospital = models.CharField(max_length=100,verbose_name=u'醫(yī)院名')
    level = models.CharField(max_length=20,verbose_name=u'醫(yī)院等級')
    genre = models.CharField(max_length=20,verbose_name=u'醫(yī)院類型')
    offce_url = models.URLField(max_length=100, verbose_name=u'醫(yī)院網(wǎng)址')
    add_time = models.DateTimeField(default=datetime.now,verbose_name=u'變更時間')

    class Meta:
        verbose_name = u'醫(yī)院'
        verbose_name_plural = verbose_name

科室model

class Office(models.Model):
    hospital = models.ForeignKey(Hospital, verbose_name=u'醫(yī)院名')
    office = models.CharField(max_length=100,verbose_name=u'科室名')
    offce_url = models.URLField(max_length=100,verbose_name=u'科室網(wǎng)址')
    describe = models.TextField(verbose_name=u'科室介紹')
    add_time = models.DateTimeField(default=datetime.now, verbose_name=u'變更時間')

    class Meta:
        verbose_name = u'科室'
        verbose_name_plural = verbose_name

醫(yī)生model

class Doctor(models.Model):
    office = models.ForeignKey(Office, verbose_name=u'科室名')
    docname = models.CharField(max_length=50,verbose_name=u'醫(yī)生姓名')
    title = models.CharField(max_length=100,verbose_name=u'職稱')
    specialize = models.TextField(verbose_name=u'擅長')
    resume = models.TextField(verbose_name=u'執(zhí)業(yè)經(jīng)歷')
    thanks = models.IntegerField(default=0, verbose_name=u'感謝信數(shù)')
    gifts = models.IntegerField(default=0, verbose_name=u'禮物數(shù)')
    hots = models.IntegerField(default=0,verbose_name=u'活躍熱度')
    helps = models.IntegerField(default=0,verbose_name=u'幫助患者數(shù)')
    offce_url = models.URLField(max_length=100, verbose_name=u'醫(yī)生網(wǎng)址')
    has_check = models.BooleanField(default=False,verbose_name=u'是否驗證')
    add_time = models.DateTimeField(default=datetime.now, verbose_name=u'變更時間')

    class Meta:
        verbose_name = u'醫(yī)生'
        verbose_name_plural = verbose_name

再次執(zhí)行數(shù)據(jù)遷移
manage.py@_admin >makemigrations
manage.py@_admin >migrate

配置地區(qū)時間
/settings.py

LANGUAGE_CODE = 'zh-hans'
TIME_ZONE = 'Asia/Shanghai'
USE_I18N = True
USE_L10N = True
USE_TZ = False