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