\documentclass[10pt,a4paper]{article}

% Packages
\usepackage{fancyhdr}           % For header and footer
\usepackage{multicol}           % Allows multicols in tables
\usepackage{tabularx}           % Intelligent column widths
\usepackage{tabulary}           % Used in header and footer
\usepackage{hhline}             % Border under tables
\usepackage{graphicx}           % For images
\usepackage{xcolor}             % For hex colours
%\usepackage[utf8x]{inputenc}    % For unicode character support
\usepackage[T1]{fontenc}        % Without this we get weird character replacements
\usepackage{colortbl}           % For coloured tables
\usepackage{setspace}           % For line height
\usepackage{lastpage}           % Needed for total page number
\usepackage{seqsplit}           % Splits long words.
%\usepackage{opensans}          % Can't make this work so far. Shame. Would be lovely.
\usepackage[normalem]{ulem}     % For underlining links
% Most of the following are not required for the majority
% of cheat sheets but are needed for some symbol support.
\usepackage{amsmath}            % Symbols
\usepackage{MnSymbol}           % Symbols
\usepackage{wasysym}            % Symbols
%\usepackage[english,german,french,spanish,italian]{babel}              % Languages

% Document Info
\author{jvanhoef}
\pdfinfo{
  /Title (oracle-naming-conventions.pdf)
  /Creator (Cheatography)
  /Author (jvanhoef)
  /Subject (Oracle naming conventions Cheat Sheet)
}

% Lengths and widths
\addtolength{\textwidth}{6cm}
\addtolength{\textheight}{-1cm}
\addtolength{\hoffset}{-3cm}
\addtolength{\voffset}{-2cm}
\setlength{\tabcolsep}{0.2cm} % Space between columns
\setlength{\headsep}{-12pt} % Reduce space between header and content
\setlength{\headheight}{85pt} % If less, LaTeX automatically increases it
\renewcommand{\footrulewidth}{0pt} % Remove footer line
\renewcommand{\headrulewidth}{0pt} % Remove header line
\renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit
% This two commands together give roughly
% the right line height in the tables
\renewcommand{\arraystretch}{1.3}
\onehalfspacing

% Commands
\newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour
\newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols
\newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns
\newcommand{\tn}{\tabularnewline} % Required as custom column type in use

% Font and Colours
\definecolor{HeadBackground}{HTML}{333333}
\definecolor{FootBackground}{HTML}{666666}
\definecolor{TextColor}{HTML}{333333}
\definecolor{DarkBackground}{HTML}{A3A3A3}
\definecolor{LightBackground}{HTML}{F3F3F3}
\renewcommand{\familydefault}{\sfdefault}
\color{TextColor}

% Header and Footer
\pagestyle{fancy}
\fancyhead{} % Set header to blank
\fancyfoot{} % Set footer to blank
\fancyhead[L]{
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{C}
    \SetRowColor{DarkBackground}
    \vspace{-7pt}
    {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent
        \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}}
    }
\end{tabulary}
\columnbreak
\begin{tabulary}{11cm}{L}
    \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Oracle naming conventions Cheat Sheet}}}} \\
    \normalsize{by \textcolor{DarkBackground}{jvanhoef} via \textcolor{DarkBackground}{\uline{cheatography.com/86407/cs/20091/}}}
\end{tabulary}
\end{multicols}}

\fancyfoot[L]{ \footnotesize
\noindent
\begin{multicols}{3}
\begin{tabulary}{5.8cm}{LL}
  \SetRowColor{FootBackground}
  \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}}  \\
  \vspace{-2pt}jvanhoef \\
  \uline{cheatography.com/jvanhoef} \\
  \end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}}  \\
   \vspace{-2pt}Not Yet Published.\\
   Updated 29th July, 2019.\\
   Page {\thepage} of \pageref{LastPage}.
\end{tabulary}
\vfill
\columnbreak
\begin{tabulary}{5.8cm}{L}
  \SetRowColor{FootBackground}
  \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}}  \\
  \SetRowColor{white}
  \vspace{-5pt}
  %\includegraphics[width=48px,height=48px]{dave.jpeg}
  Measure your website readability!\\
  www.readability-score.com
\end{tabulary}
\end{multicols}}




\begin{document}
\raggedright
\raggedcolumns

% Set font size to small. Switch to any value
% from this page to resize cheat sheet text:
% www.emerson.emory.edu/services/latex/latex_169.html
\footnotesize % Small font.

\begin{multicols*}{2}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-table\}\} Tabel - Shortname}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{De shortname van een tabel is een 3 of 4-lettercode. Deze komt terug in de benamingen van de constraints, triggers, indexes, aliassen, enz...} \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{\{\{bt\}\}{\bf{Tabel 2 of meer woorden}}\{\{nl\}\}{[}1e letter 1e woord{]} + {[}1e letter 2e woord{]} + {[}laatste letter laatste woord{]}\{\{nl\}\}OPTION\_CONTRACT = OCT\{\{nl\}\}OPTION\_CONTRACT\_EXERCISE = OCE\{\{nl\}\}OPTION\_MARKET\_PRICE = OME} \tn 
% Row Count 8 (+ 5)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{\{\{bt\}\}{\bf{Tabel 1 woord}}\{\{nl\}\} {[}1e + 2e letter{]} + {[}laatste letter{]} \{\{nl\}\}UNIT = UNT \{\{nl\}\}TRUCK = TRK} \tn 
% Row Count 10 (+ 2)
% Row 3
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{\{\{bt\}\}{\bf{Tabel is een LANGUAGE tabel}}\{\{nl\}\}{[}Normale berekening{]}+L \{\{nl\}\}UNIT\_LANGUAGE = UNTL} \tn 
% Row Count 12 (+ 2)
% Row 4
\SetRowColor{LightBackground}
\mymulticolumn{1}{x{8.4cm}}{\{\{bt\}\}Indien er al een identieke shortname in gebruik is moet je variëren. Voor reeds geldende standaarden kan je afwijken in queries en code (bv. alias).} \tn 
% Row Count 16 (+ 4)
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{5.84 cm} x{2.16 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-table\}\} Tabel}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}Tabelnaam in Engels enkelvoud. Waar mogelijk voluit, afgekort tot max lengte 30.} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
Tabel voor Forms data & FRM\_{[}NAAM{]} \tn 
% Row Count 3 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Tabel voor Print data & PRINT\_{[}NAAM{]} \tn 
% Row Count 5 (+ 2)
% Row 3
\SetRowColor{white}
Tabel voor Exact data & XA\_{[}NAAM{]} \tn 
% Row Count 6 (+ 1)
% Row 4
\SetRowColor{LightBackground}
Tabel met DMS2 data (oud systeem) & DMS2\_{[}NAAM{]} \tn 
% Row Count 8 (+ 2)
% Row 5
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{\{\{bt\}\}Volgende tabellen hebben standaard afkortingen.} \tn 
% Row Count 10 (+ 2)
% Row 6
\SetRowColor{LightBackground}
\{\{bt\}\}ARTICLE & \{\{bt\}\}ART \tn 
% Row Count 11 (+ 1)
% Row 7
\SetRowColor{white}
ART\_GROUP & ART\_GR \tn 
% Row Count 12 (+ 1)
% Row 8
\SetRowColor{LightBackground}
BOAT & B \tn 
% Row Count 13 (+ 1)
% Row 9
\SetRowColor{white}
BOAT\_TRIP & BT \tn 
% Row Count 14 (+ 1)
% Row 10
\SetRowColor{LightBackground}
BOAT\_TRIP\_ARTICLE & BTA \tn 
% Row Count 15 (+ 1)
% Row 11
\SetRowColor{white}
CONTRACT & C \tn 
% Row Count 16 (+ 1)
% Row 12
\SetRowColor{LightBackground}
CIRCLE & CIRC \tn 
% Row Count 17 (+ 1)
% Row 13
\SetRowColor{white}
CONTRACT\_PERIOD & CP \tn 
% Row Count 18 (+ 1)
% Row 14
\SetRowColor{LightBackground}
DLV & D \tn 
% Row Count 19 (+ 1)
% Row 15
\SetRowColor{white}
DLV\_DET & DD \tn 
% Row Count 20 (+ 1)
% Row 16
\SetRowColor{LightBackground}
DLV\_DET\_ALLOC & DDA \tn 
% Row Count 21 (+ 1)
% Row 17
\SetRowColor{white}
FWD & FWD \tn 
% Row Count 22 (+ 1)
% Row 18
\SetRowColor{LightBackground}
FWD\_DET & FWDD \tn 
% Row Count 23 (+ 1)
% Row 19
\SetRowColor{white}
FWD\_DET\_ALLOC & FWDDA \tn 
% Row Count 24 (+ 1)
% Row 20
\SetRowColor{LightBackground}
INV & I \tn 
% Row Count 25 (+ 1)
% Row 21
\SetRowColor{white}
INV\_LINE & IL \tn 
% Row Count 26 (+ 1)
% Row 22
\SetRowColor{LightBackground}
LOCATION & LOC \tn 
% Row Count 27 (+ 1)
% Row 23
\SetRowColor{white}
RELATION & REL \tn 
% Row Count 28 (+ 1)
% Row 24
\SetRowColor{LightBackground}
RELEASE & RLS \tn 
% Row Count 29 (+ 1)
% Row 25
\SetRowColor{white}
TENDER & TND \tn 
% Row Count 30 (+ 1)
\end{tabularx}
\par\addvspace{1.3em}

\vfill
\columnbreak
\begin{tabularx}{8.4cm}{x{5.84 cm} x{2.16 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-table\}\} Tabel (cont)}}  \tn
% Row 26
\SetRowColor{LightBackground}
TRUCK\_PLAN & TP \tn 
% Row Count 1 (+ 1)
% Row 27
\SetRowColor{white}
WASHOUT & WO \tn 
% Row Count 2 (+ 1)
% Row 28
\SetRowColor{LightBackground}
WASHOUT\_PERIOD & WOP \tn 
% Row Count 3 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.2 cm} x{4.8 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-columns\}\} Kolom - Naam / Afkorting}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{Kolomnaam in Engels enkelvoud. Waar mogelijk voluit, afgekort tot max lengte 30. De opgelijste namen zijn vaste gereserveerde namen of afkortingen.} \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{\{\{bt\}\}{\bf{Key}}} \tn 
% Row Count 4 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Primary Key & SEQ\_NR \tn 
% Row Count 5 (+ 1)
% Row 3
\SetRowColor{white}
Primary Key (user) & CODE \tn 
% Row Count 7 (+ 2)
% Row 4
\SetRowColor{LightBackground}
Foreign Key & {[}FK tabel shortname{]}\_{[}PK kolomnaam{]} \tn 
% Row Count 9 (+ 2)
% Row 5
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{\{\{bt\}\}{\bf{Type aanduidingen}}} \tn 
% Row Count 10 (+ 1)
% Row 6
\SetRowColor{LightBackground}
 & STATUS \tn 
% Row Count 11 (+ 1)
% Row 7
\SetRowColor{white}
S(ale) of P(urchase) & SLS\_PUR\_TYPE \tn 
% Row Count 13 (+ 2)
% Row 8
\SetRowColor{LightBackground}
Taalcode (bv. NL,FR,EN) & LANGUAGE\_CODE \tn 
% Row Count 15 (+ 2)
% Row 9
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{\{\{bt\}\}{\bf{Audit}}} \tn 
% Row Count 16 (+ 1)
% Row 10
\SetRowColor{LightBackground}
Datum toegevoegd & DATE\_ADDED \tn 
% Row Count 17 (+ 1)
% Row 11
\SetRowColor{white}
User toegevoegd & USER\_ADDED \tn 
% Row Count 18 (+ 1)
% Row 12
\SetRowColor{LightBackground}
Datum gewijzigd & DATE\_MODIFIED \tn 
% Row Count 19 (+ 1)
% Row 13
\SetRowColor{white}
User gewijzigd & USER\_MODIFIED \tn 
% Row Count 20 (+ 1)
% Row 14
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bt\}\}{\bf{Getallen}}} \tn 
% Row Count 21 (+ 1)
% Row 15
\SetRowColor{white}
Hoeveelheid & QTY\_ \tn 
% Row Count 22 (+ 1)
% Row 16
\SetRowColor{LightBackground}
Bedragen & AMT\_ \tn 
% Row Count 23 (+ 1)
% Row 17
\SetRowColor{white}
Metric Ton & \_MT \tn 
% Row Count 24 (+ 1)
% Row 18
\SetRowColor{LightBackground}
Euro & \_EUR \tn 
% Row Count 25 (+ 1)
% Row 19
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{\{\{bt\}\}{\bf{Tekst}}} \tn 
% Row Count 26 (+ 1)
% Row 20
\SetRowColor{LightBackground}
Omschrijving & DESCRIPTION \tn 
% Row Count 27 (+ 1)
% Row 21
\SetRowColor{white}
 & DESC \tn 
% Row Count 28 (+ 1)
% Row 22
\SetRowColor{LightBackground}
Korte Omschrijving & SHORT\_DESC \tn 
% Row Count 30 (+ 2)
\end{tabularx}
\par\addvspace{1.3em}

\vfill
\columnbreak
\begin{tabularx}{8.4cm}{x{3.2 cm} x{4.8 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-columns\}\} Kolom - Naam / Afkorting (cont)}}  \tn
% Row 23
\SetRowColor{LightBackground}
Code & CODE \tn 
% Row Count 1 (+ 1)
% Row 24
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{\{\{bt\}\}{\bf{Datums}}} \tn 
% Row Count 2 (+ 1)
% Row 25
\SetRowColor{LightBackground}
Datum & DATE \tn 
% Row Count 3 (+ 1)
% Row 26
\SetRowColor{white}
Maand & MONTH \tn 
% Row Count 4 (+ 1)
% Row 27
\SetRowColor{LightBackground}
Tijdstip & TIME \tn 
% Row Count 5 (+ 1)
% Row 28
\SetRowColor{white}
Van & \_FROM \tn 
% Row Count 6 (+ 1)
% Row 29
\SetRowColor{LightBackground}
Tot & \_TILL \tn 
% Row Count 7 (+ 1)
% Row 30
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{\{\{bt\}\}{\bf{Boolean}}} \tn 
% Row Count 8 (+ 1)
% Row 31
\SetRowColor{LightBackground}
Logisch verwijderd & DELETED \tn 
% Row Count 10 (+ 2)
% Row 32
\SetRowColor{white}
In Gebruik & IN\_USE \tn 
% Row Count 11 (+ 1)
% Row 33
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bt\}\}{\bf{Binair}}} \tn 
% Row Count 12 (+ 1)
% Row 34
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{Geen vaste naamgeving maar gebruik CLOB, BLOB, BIN, ...} \tn 
% Row Count 14 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.952 cm} x{2.432 cm} p{1.216 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{3}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-bars\}\} Record Type - Vaste Alias}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{3}{x{8.4cm}}{\{\{bb\}\}Bepaalde type records hebben vaste afkortingen of aliassen} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
 & Sale & SLS \tn 
% Row Count 3 (+ 1)
% Row 2
\SetRowColor{LightBackground}
 & Purchase & PUR \tn 
% Row Count 4 (+ 1)
% Row 3
\SetRowColor{white}
RELATION & Broker & BRK \tn 
% Row Count 5 (+ 1)
% Row 4
\SetRowColor{LightBackground}
DLV\_DET\_ALLOC & Purchase & DDAP \tn 
% Row Count 6 (+ 1)
% Row 5
\SetRowColor{white}
DLV\_DET\_ALLOC & Sale & DDAS \tn 
% Row Count 7 (+ 1)
% Row 6
\SetRowColor{LightBackground}
DLV\_DET & Purchase & DDP \tn 
% Row Count 8 (+ 1)
% Row 7
\SetRowColor{white}
DLV\_DET & Sale & DDS \tn 
% Row Count 9 (+ 1)
% Row 8
\SetRowColor{LightBackground}
TRUCK\_PLAN & Group & TPG \tn 
% Row Count 10 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}---}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{5.548 cm} p{1.292 cm} p{0.76 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{3}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-columns\}\} Kolom - Vaste Afkortingen}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{3}{x{8.4cm}}{\{\{bb\}\}Gangbare (afgekorte) benamingen voor bepaalde begrippen in kolomnamen.} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
Condition & COND &  \tn 
% Row Count 3 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Currency & CY &  \tn 
% Row Count 4 (+ 1)
% Row 3
\SetRowColor{white}
Invoice Currency & ICY &  \tn 
% Row Count 5 (+ 1)
% Row 4
\SetRowColor{LightBackground}
Load & LD &  \tn 
% Row Count 6 (+ 1)
% Row 5
\SetRowColor{white}
Local Currency & LCY &  \tn 
% Row Count 7 (+ 1)
% Row 6
\SetRowColor{LightBackground}
Location Load & LL &  \tn 
% Row Count 8 (+ 1)
% Row 7
\SetRowColor{white}
Location Unload & LU &  \tn 
% Row Count 9 (+ 1)
% Row 8
\SetRowColor{LightBackground}
Transaction Currency & TCY &  \tn 
% Row Count 10 (+ 1)
% Row 9
\SetRowColor{white}
Unload & ULD &  \tn 
% Row Count 11 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}---}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{1.84 cm} x{6.16 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-key\}\} Constraint}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}Key naam aan de hand van de tabel shortnames, max lengte 30.} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}{[}SRC{]} = shortname source (bron) tabel\{\{nl\}\}{[}TGT{]} = shortname target (doel) tabel} \tn 
% Row Count 4 (+ 2)
% Row 2
\SetRowColor{LightBackground}
Primary & PK\_{[}SRC{]} \tn 
% Row Count 5 (+ 1)
% Row 3
\SetRowColor{white}
Foreign & FK\_{[}SRC{]}\_{[}TGT{]} \tn 
% Row Count 6 (+ 1)
% Row 4
\SetRowColor{LightBackground}
Check & CH\_{[}SRC{]}\_{[}kolomnaam{]} \tn 
% Row Count 7 (+ 1)
% Row 5
\SetRowColor{white}
 & CH\_{[}SRC{]}\_{[}beschrijving{]} \tn 
% Row Count 8 (+ 1)
% Row 6
\SetRowColor{LightBackground}
Unique & UK\_{[}SRC{]}\_{[}kolomnaam{]} \tn 
% Row Count 9 (+ 1)
% Row 7
\SetRowColor{white}
 & UK\_{[}SRC{]}\_{[}beschrijving{]} \tn 
% Row Count 10 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{p{0.8 cm} p{0.8 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-sort-down\}\} Sequences}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}Sequence naam aan de hand van de tabel shortname, max lengte 30.} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{SEQ\_{[}SRC{]}} \tn 
% Row Count 3 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{4.88 cm} x{3.12 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-stopwatch\}\} Trigger}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}Trigger naam aan de hand van de tabel shortnames, max lengte 30.\{\{nl\}\}We delen DML triggers op adhv timing} \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}{[}SRC{]} = shortname source (bron) tabel} \tn 
% Row Count 4 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Audit & TRG\_{[}SRC{]}\_AUDIT \tn 
% Row Count 5 (+ 1)
% Row 3
\SetRowColor{white}
Before statement & TRG\_{[}SRC{]}\_BS \tn 
% Row Count 6 (+ 1)
% Row 4
\SetRowColor{LightBackground}
Before row & TRG\_{[}SRC{]}\_BR \tn 
% Row Count 7 (+ 1)
% Row 5
\SetRowColor{white}
After row & TRG\_{[}SRC{]}\_AR \tn 
% Row Count 8 (+ 1)
% Row 6
\SetRowColor{LightBackground}
After statement & TRG\_{[}SRC{]}\_AS \tn 
% Row Count 9 (+ 1)
% Row 7
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{\{\{bt\}\}Ter verduidelijking kan je een extra suffix gebruiken. Dit is aan te raden voor onderstaande gevallen} \tn 
% Row Count 12 (+ 3)
% Row 8
\SetRowColor{LightBackground}
\{\{bt\}\}Validatie na statement & \{\{bt\}\}\_VALIDATE \tn 
% Row Count 14 (+ 2)
% Row 9
\SetRowColor{white}
Interface Eurosilo & \_ES\_MODIFIED \tn 
% Row Count 15 (+ 1)
% Row 10
\SetRowColor{LightBackground}
Meerdere triggers & \_{[}VERDUIDELIJKING{]} \tn 
% Row Count 17 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{4.64 cm} x{3.36 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-table\}\} View}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}View naam aan de hand van de tabel naam/namen of shortname(s), max lengte 30. Een gecombineerde view zet SLS tegen PUR zijde langs elkaar.} \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
View & VW\_{[}NAAM{]} \tn 
% Row Count 4 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Gecombineerde view & VW\_CMB\_{[}NAAM{]} \tn 
% Row Count 5 (+ 1)
% Row 3
\SetRowColor{white}
Materialized view & MV\_{[}NAAM{]} \tn 
% Row Count 6 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{4.16 cm} x{3.84 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-bullseye\}\} Type}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}Type naam aan de hand van de tabel shortname, max lengte 30.} \tn 
% Row Count 2 (+ 2)
% Row 1
\SetRowColor{white}
Object type & TP\_{[}SRC{]} \tn 
% Row Count 3 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Collection type & TYPE\_TAB\_{[}SRC{]} \tn 
% Row Count 4 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{p{0.8 cm} p{0.8 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-list\}\} Function}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}Function naam adhv de actie die de functie uitvoert. Bvb. GET\_ Er is weinig nood aan losse functions vermits alles kan gepackaged worden. (Er bestaan er nu geen)} \tn 
% Row Count 4 (+ 4)
% Row 1
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{GET\_COMMA\_LIST} \tn 
% Row Count 5 (+ 1)
% Row 2
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{GET\_USERNAME} \tn 
% Row Count 6 (+ 1)
% Row 3
\SetRowColor{white}
\mymulticolumn{2}{x{8.4cm}}{SET\_USER\_CONTEXT} \tn 
% Row Count 7 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{3.84 cm} x{4.16 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-list\}\} Procedure}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}Procedure naam adhv de actie die de procedure uitvoert. Op termijn zouden deze beter gepackaged worden.} \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
Procedure & SP\_{[}OMSCHRIJVING{]} \tn 
% Row Count 4 (+ 1)
% Row 2
\SetRowColor{LightBackground}
Tijdelijk & SP\_ADMTMP\_{[}NAAM{]} \tn 
% Row Count 5 (+ 1)
% Row 3
\SetRowColor{white}
Systeembeheer & SP\_ADMSYS\_{[}NAAM{]} \tn 
% Row Count 6 (+ 1)
% Row 4
\SetRowColor{LightBackground}
Utilities & SP\_ADMUTL\_{[}NAAM{]} \tn 
% Row Count 7 (+ 1)
% Row 5
\SetRowColor{white}
VATLA procedures & SP\_ADMVTL\_{[}NAAM{]} \tn 
% Row Count 8 (+ 1)
% Row 6
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{Deze zijn incorrect benoemd en zouden moeten verhuizen naar 1 van de vorige 4 categoriën} \tn 
% Row Count 10 (+ 2)
% Row 7
\SetRowColor{white}
 & SP\_ADMIN\_{[}NAAM{]} \tn 
% Row Count 11 (+ 1)
% Row 8
\SetRowColor{LightBackground}
Create print & SP\_CPRN\_{[}NAAM{]} \tn 
% Row Count 12 (+ 1)
% Row 9
\SetRowColor{white}
Getters & SP\_GET\_{[}NAAM{]} \tn 
% Row Count 13 (+ 1)
% Row 10
\SetRowColor{LightBackground}
Setters & SP\_SET\_{[}NAAM{]} \tn 
% Row Count 14 (+ 1)
% Row 11
\SetRowColor{white}
Webservices & SP\_WS\_{[}NAAM{]} \tn 
% Row Count 15 (+ 1)
% Row 12
\SetRowColor{LightBackground}
Exact & SP\_XA\_{[}NAAM{]} \tn 
% Row Count 16 (+ 1)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{x{5.12 cm} x{2.88 cm} }
\SetRowColor{DarkBackground}
\mymulticolumn{2}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-list\}\} Package}}  \tn
% Row 0
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{\{\{bb\}\}Package naam adhv de functie die de package heeft. Voorkeur is om alle procedures en functions in packages te steken.} \tn 
% Row Count 3 (+ 3)
% Row 1
\SetRowColor{white}
Algemene package & PKG\_{[}NAME{]} \tn 
% Row Count 4 (+ 1)
% Row 2
\SetRowColor{LightBackground}
API package & PKG\_API\_{[}NAME{]} \tn 
% Row Count 5 (+ 1)
% Row 3
\SetRowColor{white}
FRM package & PKG\_{[}NAAM\_FORM{]} \tn 
% Row Count 7 (+ 2)
% Row 4
\SetRowColor{LightBackground}
Handle package voor trigger & PKG\_HDL\_{[}NAME{]} \tn 
% Row Count 9 (+ 2)
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\SetRowColor{LightBackground}
\mymulticolumn{2}{x{8.4cm}}{{[}NAME{]} is in dit geval beter de volledige naam van de tabel ipv de shortname. Een package is op db niveau niet gekoppeld aan een tabel.}  \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}--}
\end{tabularx}
\par\addvspace{1.3em}

\begin{tabularx}{8.4cm}{X}
\SetRowColor{DarkBackground}
\mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{\{\{fa-list\}\} Package}}  \tn
\SetRowColor{white}
\mymulticolumn{1}{x{8.4cm}}{Naming conventions voor code in PL/SQL te vinden op de database in de package PKG\_NAMING\_CONVENTIONS% Row Count 2 (+ 2)
} \tn 
\hhline{>{\arrayrulecolor{DarkBackground}}-}
\end{tabularx}
\par\addvspace{1.3em}


% That's all folks
\end{multicols*}

\end{document}