Announcement Module
No announcement yet.

database design help

Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • database design help


    I am planning to design a database with 8 tables with some columns to store the register information(Current Version is A). Also in future i am going to modify the register information (modified version of the register is version B) and store the data related to version B. Currently i am planning to query data related to version A but in future i am planning to query data related to version A as well as B from the database. Can anyone please help me to design the database with the revision control.? How can i get the information from database related to Revision A or revision B?

  • #2
    Use columns with type set. e.g.

    mysql> create table example (`version` set ('a','b') not null default 'a', index (`version`)) engine=innodb;mysql> describe example;+---------+--------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+---------+--------------+------+-----+---------+-------+| version | set('a','b') | NO | MUL | a | |+---------+--------------+------+-----+---------+-------+1 row in set (0.00 sec)

    That way a particular "feature" can belong to version A, version B or both.