backend_server

Tables (6)

Category (카테고리)

  • id (아이디) — number — Primary key — NOT NULL
  • Name (이름) — String
  • UrlString (Url) — String

Content (내용)

  • id (아이디) — number — Primary key — NOT NULL
  • ParentDirectoryId (부모아이디) — number
  • CreateUserId (유저아이디) — number
  • OwnerUserId (오너아이디) — number
  • Name (이름) — String
  • FileSize (파일사이즈) — number
  • Status (상태) — enum
  • Date (날짜) — Date

Directory (디렉토리)

  • ID (Key) — number — Primary key — NOT NULL
  • ParentDirectoryId (Field) — String
  • OwnerUserId (Field2) — String
  • CreatedDate (Field3) — Date

MarketContent (마켓콘텐츠)

  • id (아이디) — number — Primary key — NOT NULL
  • ContentId (내용번호) — number
  • Category (카테고리) — String
  • SubCategory (서브카테고리) — String
  • Title (제목) — String
  • UrlSlug (Url) — String
  • PublishedDate (발행날짜) — Date

SubCategory (서브카테고리)

  • id (아이디) — number — Primary key — NOT NULL
  • ParentCategoryId (부모아이디) — number
  • Name (이름) — String
  • UrlString (Url) — String

users (유저기능)

  • id (아이디) — number — Primary key — NOT NULL
  • SecurityStamp (Field) — String
  • UserName (유저이름) — String
  • NormailzedUserName (일반적인(?) 유저이름) — String
  • Email (이메일) — String
  • NormailzedUserEmail (일반적인 유저네임) — String
  • Password (비밀번호) — String
  • Nickname (닉네임) — String
  • CurrentPoint (Field2) — integer
  • UsedPoint (Field3) — integer
  • RegisteredDate (Field4) — Date