pro
Tables (3)
internal_promotion
- 프로모션_id (promotion_id) — Primary key — NOT NULL
- 프로모션_명 (promotion_nm) — varchar(300) — NOT NULL
- 프로모션_설명 (promotion_desc) — text
- 상품_수량 (quantity) — int — NOT NULL
- 페이지_url_경로 (page_url_path) — varchar(1000)
- 노출_시작_일시 (start_dtm) — datetime — NOT NULL
- 노출_종료_일시 (end_dtm) — datetime — NOT NULL
- 응모_시작_일시 (apply_start_dtm) — datetime — NOT NULL
- 응모_종료_일시 (apply_end_dtm) — datetime — NOT NULL
- 등록일 (register_dtm) — datetime — NOT NULL
internal_promotion_applicant
- applicant_id — bigint
- promotion_id — int
- member_id — bigint — NOT NULL
- device_uuid — varchar(255)
- register_dtm — datetime — NOT NULL
internal_promotion_push
- 푸시_id (push_id) — int — Primary key — NOT NULL
- 프로모션_id (promotion_id) — Foreign key → internal_promotion.프로모션_id — NOT NULL
- push_type_id — bigint — NOT NULL
- page_move_url — varchar(1000)
- 푸시_발송_일자 (push_send_dtm) — datetime — NOT NULL
- 등록일 (register_dtm) — datetime — NOT NULL