Example #1
0
        private void WriteIndicators(StreamWriter writer, Table table, Column column, ForeignKeyIndicator foreignKeyIndicator)
        {
            List<string> indicators = new List<string>();
            if (column.InPrimaryKey)
            {
                indicators.Add("PK");
            }

            string indexIndicator = FindIndexIndicator(table, column);
            if (indexIndicator != null)
            {
                indicators.Add(ToHtml(indexIndicator));
            }

            if (foreignKeyIndicator != null)
            {
                indicators.Add(ToHtml(foreignKeyIndicator.Identifier));
            }

            writer.Write("<td>");
            if (indicators.Count > 0)
            {
                writer.Write(string.Join("<br/>", indicators));
            }
            writer.WriteLine("</td>");
        }
Example #2
0
 private void WriteDataType(StreamWriter writer, Column column, ForeignKeyIndicator foreignKeyIndicator)
 {
     string columnType = DatabaseColumnTypeMapper.GetColumnTypeString(DatabaseTargetSystem, column);
     columnType = columnType.Replace(" NOT NULL", "");
     string dataType = ToHtml(columnType);
     if (foreignKeyIndicator != null)
     {
         dataType += "<br/>" + ToHtml(foreignKeyIndicator.ToTableText);
     }
     writer.WriteLine("<td>" + dataType + "</td>");
 }