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