Database columns data type for recurring events i

Scheduler ASP.NET MVC
#1

A recurring event is stored in the database as a single record that contains all fields of a regular event plus 3 additional:
rec_type - (varchar) defines the logic of repetition. This field is filled in automatically
event_length - (long int) the actual time length of an event in seconds
event_pid - (int) the parent id of a series of events
How should the type needs to be defined in sqlserver express 2012 :

  1. varchar as varchar(max) or varcher(limit) what is the limit?
  2. longint should be defined as bigint?
  3. Is it possible to save the data in same columns but in other names (not the default ones which are used for other relevant data)?
#2

Hi,
sorry, we’ll add details to the article in the nearest time
The column types are following

CREATE TABLE [Events] ( [id] INT IDENTITY (1, 1) NOT NULL, [text] TEXT NULL, [start_date] DATETIME NOT NULL, [end_date] DATETIME NOT NULL, [event_length] BIGINT NULL, [rec_type] NVARCHAR(50) NULL, [event_pid] INT NULL, PRIMARY KEY (id) );

  1. Is it possible to save the data in same columns but in other names (not the default ones which are used for other relevant data)?

The database columns can have arbitrary names, however when the data is loaded to the scheduler - there are requirements for the names of properties of a data objects.
You can either rename the property in your model class, or use DHXJson attribute to set the mappings