-- table 
-- [dbo] - "database owner"
-- IDENTITY - automatic number

use student_cz
go

CREATE TABLE [dbo].[STUDENT](
	[ID_STUDENT] [int] IDENTITY(1,1) NOT NULL,
	[SURNAME] [varchar](50) NOT NULL,
	[STUDENT_NAME] [varchar](50) NULL,
	[EMAIL] [varchar](50) NULL,
	[ADDRESS] [varchar](200) NULL
) ON [PRIMARY]

GO


CREATE TABLE [dbo].[SUBJECTS](
	[ID_SUBJECT] [int] IDENTITY(1,1) NOT NULL,
	[SUBJECT_NAME] [varchar](100) NULL,
	[SUBJECT_KREDIT] [int] NULL
) ON [PRIMARY]


GO
CREATE TABLE [dbo].[RESULT](
	[ID_RESULT] [int] IDENTITY(1,1) NOT NULL,
	[ID_STUDENT] [int] NOT NULL,
	[EXAM_DATE] [datetime] NULL,
	[ID_SUBJECT] [int] NOT NULL,
	[EXAM_RESULT_POINTS] [smallint] NULL,
	[EXAM_RESULT] [smallint] NULL
) ON [PRIMARY]

GO
CREATE TABLE [dbo].[LOG](
	[ID_LOG] [int] IDENTITY(1,1) NOT NULL,
	[LOG_DATE] [datetime] NULL,
	[LOG_TEXT] [varchar](100) NULL,
	[LOG_ID_USER] [varchar](100) NULL
) ON [PRIMARY]

GO