DB Style Guide

Jump to navigation Jump to search
  1. Tablenames must be self understandable, separated by _ character
    • Example: media_info_type
  2. Column Rules:
    1. Column names have to be lower case
    2. Columnnames must start with a table name short cut (tnsc)
      • Example: select mit_id from media_info_type;
    3. Primary key is mandatory and must be <tnsc>_id BIGINT NOT NULL AUTO_INCREMENT