Subscribe

Tables (4)

ContentHistory (Statistics)

  • UserId (Key) — number — Foreign key → Subscribe.UserId — NOT NULL
  • ContentId (Key2) — number — Foreign key → Contents.ContentId — NOT NULL
  • CreateDate (Field) — datetime
  • UpdateDate (Field2) — datetime

Contents

  • ContentId (Key) — number — Primary key — NOT NULL
  • ContentType (Field) — number
  • ContentName (Field2) — string
  • Content (Field3) — data
  • Createdate (Field4) — datetime
  • Updatedate (Field5) — datetime

Subscribe

  • UserId (Key2) — number — Foreign key → User.UserId — NOT NULL
  • SubscribeType (Field) — number
  • SubscribePeriod (Field2) — datetime
  • CreateDate (Field3) — datetime
  • UpdateDate (Field4) — datetime

User

  • UserId (Key) — number — Primary key — NOT NULL
  • UserInfo (Field) — string
  • CreateDate (Field2) — datetime
  • UpdateDate (Field3) — datetime