dbo.Partners

Tables (6)

T_Banner (배너 및 팝업)

  • BannerIdx (PK) — INT(IDENTITY) — Primary key — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDT (delete datetime) — DATETIME
  • Title (title) — VARCHAR(100)
  • Img (banner image) — VARCHAR(200)
  • LinkURL (link url) — VARCHAR(1000)
  • LinkTarget (link target) — VARCHAR(20)
  • Type (type) — INT
  • DisplayType (display type) — INT
  • Enable (enable) — BIT
  • BackgroundColor (background color) — VARCHAR(7)
  • Width (width) — SMALLINT
  • Height (height) — SMALLINT
  • Align (align) — VARCHAR(20)
  • BlindDay (blind day) — SMALLINT
  • StartDT (start datetime) — DATETIME
  • EndDT (end datetime) — DATETIME
  • Sort (sort) — INT

T_Board (게시판)

  • BoardIdx (PK) — INT(IDENTITY) — Primary key — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDT (delete datetime) — DATETIME
  • BoardTypeIdx (FK1) — INT — Foreign key → T_BoardType.BoardTypeIdx — NOT NULL
  • BoardCategoryIdx (FK2) — INT — Foreign key → T_BoardCategory.BoardCategoryIdx — NOT NULL
  • Title (title) — NVARCHAR(100)
  • UserIdx (useridx) — INT
  • Contents — NVARCHAR(MAX)
  • ContentsText (Contents without tag) — VARCHAR(MAX)
  • Display (display) — BIT
  • ViewCnt (view count) — INT
  • NoticeChk (notice Check) — BIT
  • NoticeStartDT (notice start datetime) — DATETIME

T_BoardCategory (게시판 카테고리)

  • BoardCategoryIdx (PK) — INT(IDENTITY) — Primary key — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDT (delete datetime) — DATETIME
  • BoardTypeIdx (FK) — INT — Foreign key → T_BoardType.BoardTypeIdx — NOT NULL
  • Name (Category name) — NVARCHAR(100)

T_BoardType (게시판 타입)

  • BoardTypeIdx (PK) — INT(IDENTITY) — Primary key — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDT (delete datetime) — DATETIME
  • Name (board type name) — NVARCHAR(100)

T_Partner (파트너)

  • PartnerIdx (PK) — INT(IDENTITY) — Primary key — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDT (delete datetime) — DATETIME
  • Name (partner name) — VARCHAR(100)
  • Img (partner image) — VARCHAR(200)
  • LinkURL (link url) — VARCHAR(1000)
  • Display (display) — BIT
  • Sort (sort) — INT

T_Startup (스타트업)

  • StartupIdx (PK) — INT(IDENTITY) — Primary key — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDT (delete datetime) — DATETIME
  • Img (portfolio image) — VARCHAR(200)
  • Name (company name) — VARCHAR(100)
  • URL (company url) — VARCHAR(1000)
  • Summary (company summary) — VARCHAR(300)
  • Owner (company owner) — VARCHAR(30)
  • Address (company address) — VARCHAR(100)
  • LinkURL (link url) — VARCHAR(1000)
  • Display (display) — BIT
  • Sort (sort) — INT