› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
changsha
V2EX  ›  MySQL

这个结构怎么设计?

  •  
  •   changsha · Oct 10, 2014 · 3743 views
    This topic created in 4369 days ago, the information mentioned may be changed or developed.
    language:
    +----------+------------------+
    | Field    | Type             |
    +----------+------------------+
    | id       | int(10) unsigned |
    | language | varchar(45)      |
    +----------+------------------+
    
    country:
    
    +-------+------------------+
    | Field | Type             |
    +-------+------------------+
    | id    | int(10) unsigned |
    | name  | varchar(45)      |
    +-------+------------------+
    
    goods:
    +--------------+------------------------+
    | Field        | Type                   |
    +--------------+------------------------+
    | id           | int(10) unsigned       |
    | name         | varchar(200)           |
    | model        | varchar(45)            |
    | description  | varchar(200)           |
    | price        | decimal(10,2) unsigned |
    +--------------+------------------------+
    

    需求:
    1、有1人做商品信息录入[基本信息]
    2、A、B、C 国家进行信息本地化,包括name,description,price等。model 是 unique 的,不用本地化。
    3、D 国家发现语言和基本信息一致,不用进行本地化,此时读取[基本信息]。

    Supplement 1  ·  Oct 10, 2014
    E 国家可只本地化价格,其他信息按照[基础信息]来显示。
    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   974 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 17ms · UTC 18:42 · PVG 02:42 · LAX 11:42 · JFK 14:42
    ♥ Do have faith in what you're doing.