EVENT2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EVENT2 (
    ACADELICEVENTENDTIME,
    ACADEMICEVENTINSTRUCTOR,
    ACADEMICEVENTINSTRUCTORNAME,
    ACADEMICEVENTINSTRUCTORTYPE,
    ACADEMICEVENTISDELETED,
    ACADEMICEVENTISEXTERNAL,
    ACADEMICEVENTISLOCKED,
    ACADEMICEVENTLANGUAGE,
    ACADEMICEVENTLOCATION,
    ACADEMICEVENTLOCATIONNAME,
    ACADEMICEVENTLOCATIONSHORTNAME,
    ACADEMICEVENTNAME,
    ACADEMICEVENTPACKAGE,
    ACADEMICEVENTPACKAGENAME,
    ACADEMICEVENTPACKAGESHORTNAME,
    ACADEMICEVENTROOM,
    ACADEMICEVENTROOMNAME,
    ACADEMICEVENTROOMSHORTNAME,
    ACADEMICEVENTSHORTNAME,
    ACADEMICEVENTSTARTDATE,
    ACADEMICEVENTSTARTTIME,
    ACADEMICEVENTTYPE,
    ACADEMICEVENTTYPECATEGORY,
    ACADEMICEVENTTYPECATEGORYNAME,
    ACADEMICEVENTTYPENAME,
    ACADEMICEVENTTYPESHORTNAME,
    ACADEMICSESSION,
    ACADEMICSESSIONNAME,
    ACADEMICYEAR,
    ACADEMICYEARNAME,
    ACADEMUCEVENTENDDATE,
    ACDMCEVENTINSTRUCTORTYPENAME,
    ACDMCEVENTTYPEDELIVERYMODE,
    ACDMCEVENTTYPEDELIVERYMODENAME,
    ACDMCEVTCANCELLATIONREASON,
    ACDMCEVTCANCELLATIONREASONNAME,
    ACDMCEVTTYPEAPPRAISALTYPE,
    ACDMCEVTTYPEAPPRAISALTYPENAME,
    ACDMCEVTTYPETEACHINGMETHOD,
    ACDMCEVTTYPETEACHINGMETHODNAME,
    ISEVTYPEATTENDANCECOMPULSORY,
    NUMBEROFTOTALBOOKINGS,
    STUDYMODULE,
    STUDYMODULENAME,
    STUDYMODULESHORTNAME
);