mysimulation/server/FSO.Server.Database/DA/LotVisits/DbLotVisit.cs

using FSO.Common.Enum;
using System;

namespace FSO.Server.Database.DA.LotVisitors
{
    public class DbLotVisit
    {
        public int lot_visit_id { get; set; }
        public uint avatar_id { get; set; }
        public int lot_id { get; set; }
        public DbLotVisitorType type { get; set; }
        public DbLotVisitorStatus status { get; set; }
        public DateTime time_created { get; set; }
        public DateTime? time_closed { get; set; }
    }

    public class DbLotVisitNhood : DbLotVisit
    {
        public uint neighborhood_id { get; set; }
        public uint location { get; set; }
        public LotCategory category { get; set; }
    }

    public enum DbLotVisitorType
    {
        owner,
        roommate,
        visitor
    }

    public enum DbLotVisitorStatus
    {
        active,
        closed,
        failed
    }
}