I am learning SQL Server. I need a bit of advice regarding data type for fields that will be referred to but will not actually themselves require values. I don't know the correct term to use(edit welcome).
I will draw a brief overview of the fields functions to try and illustrate requirement clearer. The fields with the asterisks I am calling "reference" fields, there are many more event types but just keeping example brief and hopefully clear. Table-Events should be like a junction table. I am trying to change my ERD (of which this is a small section) so that my events aren't hardcoded and I reduce redundancy and if in future new EventTypes are needed I can just update EventTypes to add them.
Edit: Each Column here represents a table with the first Table- representing the table name the second field the GUID field etc.
Table-Player Table-Events Table-EventTypes PlayerID EventsID EventTypeID firstName Minute Try* secondName Fk_EventType Conversion* Fk_team Fk_Player Penalty*
As such though Try/Conversion/Penalty will never have any data it will just be selected in the Events Table with Fk_Player and minute. So what data type should I use.