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