Magicline

Tables (4)

TB_BOARD

  • id (아이디) — bigint — Primary key — NOT NULL
  • type (게시판구분(promotion: 홍보실, notice:자료실)) — bigint — NOT NULL
  • category (카테고리명) — bigint — NOT NULL
  • title (게시물제목) — bigint — NOT NULL
  • content (게시물내용) — text
  • created_by (생성자) — varchar(100) — NOT NULL
  • created_date (생성일시) — datetime — NOT NULL
  • last_modified_by (최종수정자) — varchar(100)
  • last_modified_date (최종수정일) — datetime

TB_BOARD_FILE (..)

  • id (Key) — bigint — Primary key — NOT NULL
  • board_id (게시물아이디) — bigint — Foreign key → TB_BOARD.id — NOT NULL
  • hash_key (미디어키) — varchar(255) — NOT NULL
  • current_state (현재상태) — varchar(50)
  • upload_key (업로드키) — varchar(255)
  • path (저장경로) — varchar(255) — NOT NULL
  • name (원본파일명) — varchar(255) — NOT NULL
  • extension (확장자) — varchar(50)
  • type (MIME타입) — varchar(50)
  • size (파일사이즈) — int — NOT NULL
  • external_link (외부링크) — varchar(255)
  • created_by (생성자) — varchar(100) — NOT NULL
  • created_date (생성일시) — datetime — NOT NULL
  • last_modified_by (최종수정자) — varchar(100)
  • last_modified_date (최종수정일) — datetime

TB_POPUP

  • id (아이디) — bigint — Primary key — NOT NULL
  • type (팝업페이지(brand: 브랜드사이트, internal: 주문사이트(내부), external: 주문사이트(외부)) — varchar(50) — NOT NULL
  • title (게시물 제목) — varchar(255) — NOT NULL
  • start_date (팝업 시작날짜) — datetime — NOT NULL
  • end_date (팝업 종료날짜) — datetime — NOT NULL
  • created_by (생성자) — varchar(100) — NOT NULL
  • created_date (생성일시) — datetime — NOT NULL
  • last_modified_by (최종수정자) — varchar(100)
  • last_modified_date (최종수정일) — datetime

TB_POPUP_FILE (.)

  • id (Key) — bigint — Primary key — NOT NULL
  • popup_id (팝업아이디) — bigint — Foreign key → TB_POPUP.id — NOT NULL
  • hash_key (미디어키) — varchar(255) — NOT NULL
  • current_state (현재상태) — varchar(50)
  • upload_key (업로드키) — varchar(255)
  • path (저장경로) — varchar(255) — NOT NULL
  • name (원본파일명) — varchar(255) — NOT NULL
  • extension (확장자) — varchar(50)
  • type (MIME타입) — varchar(50)
  • size (파일사이즈) — int — NOT NULL
  • external_link (외부링크) — varchar(255)
  • created_by (생성자) — varchar(100) — NOT NULL
  • created_date (생성일시) — datetime — NOT NULL
  • last_modified_by (최종수정자) — varchar(100)
  • last_modified_date (최종수정일) — datetime