[erdiag.git] / examples / example2.html

<h2>MCD graph:</h3>
<div id="mcd"></div>

<h2>MLD graph:</h2>
<div id="mld"></div>

<h2>SQL instructions:</h2>
<div id="sql"></div>

<script src="//cdnjs.cloudflare.com/ajax/libs/underscore.js/1.8.3/underscore-min.js"></script>
<script src="parser.js"></script>
<script>
	let er =
		new ErDiags(`
			[Users]
			+id
			name VARCHAR NOT NULL
			email VARCHAR
			location VARCHAR
			birthdate DATE
			gender CHARACTER
			avatar BLOB

			[Groups]
			+id
			name VARCHAR NOT NULL
			description TEXT

			[Events]
			+id
			name VARCHAR NOT NULL
			description TEXT

			[Messages]
			+id
			date DATE NOT NULL
			content TEXT NOT NULL
			receiver INTEGER REFERENCES Users(id) NOT NULL

			[Posts]
			+id
			content TEXT NOT NULL
			date DATE NOT NULL
			type VARCHAR NOT NULL DEFAULT "Wall"
			reference INTEGER NOT NULL

			{publish}
			Posts 1
			Users *

			{send}
			Messages 1
			Users *

			{like}
			Users *
			Posts *

			{follow}
			Users *
			Users *

			{friend_with}
			Users *
			Users *

			{participate}
			Events *
			Users *
			--
			degree VARCHAR NOT NULL DEFAULT "sure"
			creator BOOLEAN

			{belong_to}
			Groups +
			Users *
			--
					creator BOOLEAN
		`);
	er.drawMcd("mcd"); //,"bubble"
	er.drawMld("mld");
	er.fillSql("sql");
</script>
Commit	Line	Data
3789126f BA	1	<h2>MCD graph:</h3>
	2	<div id="mcd"></div>
	3
	4	<h2>MLD graph:</h2>
	5	<div id="mld"></div>
	6
	7	<h2>SQL instructions:</h2>
	8	<div id="sql"></div>
	9
	10	<script src="//cdnjs.cloudflare.com/ajax/libs/underscore.js/1.8.3/underscore-min.js"></script>
	11	<script src="parser.js"></script>
	12	<script>
	13	let er =
	14	new ErDiags(`
	15	[Users]
	16	+id
	17	name VARCHAR NOT NULL
	18	email VARCHAR
	19	location VARCHAR
	20	birthdate DATE
	21	gender CHARACTER
	22	avatar BLOB
	23
	24	[Groups]
	25	+id
	26	name VARCHAR NOT NULL
	27	description TEXT
	28
	29	[Events]
	30	+id
	31	name VARCHAR NOT NULL
	32	description TEXT
	33
	34	[Messages]
	35	+id
	36	date DATE NOT NULL
	37	content TEXT NOT NULL
	38	receiver INTEGER REFERENCES Users(id) NOT NULL
	39
	40	[Posts]
	41	+id
	42	content TEXT NOT NULL
	43	date DATE NOT NULL
	44	type VARCHAR NOT NULL DEFAULT "Wall"
	45	reference INTEGER NOT NULL
	46
	47	{publish}
	48	Posts 1
	49	Users *
	50
	51	{send}
	52	Messages 1
	53	Users *
	54
	55	{like}
	56	Users *
	57	Posts *
	58
	59	{follow}
	60	Users *
	61	Users *
	62
	63	{friend_with}
	64	Users *
65	Users *
66
67	{participate}
68	Events *
69	Users *
70	--
71	degree VARCHAR NOT NULL DEFAULT "sure"
72	creator BOOLEAN
73
74	{belong_to}
75	Groups +
76	Users *
77	--
78	creator BOOLEAN
79	`);
80	er.drawMcd("mcd"); //,"bubble"
81	er.drawMld("mld");
82	er.fillSql("sql");
83	</script>