# 关于公交数据表设计的思路

**URL:** <https://www.shiqidu.com/t/topic/374>\
**Category:** 开发调优\
**Tags:** MySQL\
**Created:** [March 2, 2018, 12:58am UTC](https://www.shiqidu.com/t/topic/374 "2018-03-02T00:58:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dajiang](https://www.shiqidu.com/user_avatar/www.shiqidu.com/dajiang/32/468_2.png) [@dajiang](https://www.shiqidu.com/u/dajiang)\
**Post date:** [March 2, 2018, 12:58am UTC](https://www.shiqidu.com/t/topic/374/1 "2018-03-02T00:58:51Z")

</div>

地名一张表station\_id，station\_name。线路一张表line\_name，line\_station\_ids。站点映射路线表station\_id，line\_id。创建线路时，线路已知，添加站点进行一一存储
