Influencer

Tables (14)

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of influencer22 (campaign_sns_map)

  • Key (campaign_sns_map_id) — INT — Primary key — NOT NULL — 캠페인 채널 맵 아이디
  • Key (sns_id) — INT — Foreign key → Copy Of Copy Of Copy Of influencer2.Key — NOT NULL — sns 아이디
  • Key (campaign_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of influencer2.Key — NOT NULL — 캠페인 아이디
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field2 (created_by) — INT — NOT NULL — 생성자
  • Field3 (updated_at) — datetime — NOT NULL — 수정일시
  • Field4 (updated_by) — INT — NOT NULL — 수정자
  • Field5 (deleted_at) — datetime — 삭제일시
  • Field6 (deleted_by) — INT — 삭제자

Copy Of Copy Of Copy Of Copy Of Copy Of Copy Of influencer2 (influencerBoard_sns_map)

  • Key (influencerBoard_sns_map_id) — INT — Primary key — NOT NULL — 인플루언서 보드 sns 맵 아이디
  • Key (influencerBoard_id) — INT — Foreign key → Copy Of influencer3.Key — NOT NULL — 인플루언서 아이디
  • Key (sns_id) — INT — Foreign key → Copy Of Copy Of Copy Of influencer2.Key — NOT NULL — sns 아이디
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field2 (created_by) — INT — NOT NULL — 생성자
  • Field3 (updated_at) — datetime — NOT NULL — 수정일시
  • Field4 (updated_by) — INT — NOT NULL — 수정자
  • Field5 (deleted_at) — datetime — 삭제일시
  • Field6 (deleted_by) — INT — 삭제자

Copy Of Copy Of Copy Of Copy Of Copy Of influencer2 (influencer_campaign_map)

  • Key (influencer_campaign_map_id) — INT — Primary key — NOT NULL — 인플루언서 캠페인 맵 아이디
  • Key (influencerBoard_id) — INT — Foreign key → Copy Of influencer3.Key — NOT NULL — 인플루언서 보드 아이디
  • Key (campaignBoard_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of influencer2.Key — NOT NULL — 캠페인 아이디
  • Field (status) — ENUM — NOT NULL — 상태(approved,rejected, pending)
  • Field (request_source) — ENUM — NOT NULL — 요청자(influencer, campaign)
  • Field (bookmark) — ENUM — 북마크 여부( Y / N )
  • Field (description) — VARCHAR(50) — 요구사항
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field2 (created_by) — INT — NOT NULL — 생성자
  • Field3 (updated_at) — datetime — NOT NULL — 수정일시
  • Field4 (updated_by) — INT — NOT NULL — 수정자
  • Field5 (deleted_at) — datetime — 삭제일시
  • Field6 (deleted_by) — INT — 삭제자

Copy Of Copy Of Copy Of Copy Of Copy Of influencer232 (advertiser_point_map)

  • Key (advertiser_point_map_id) — INT — Primary key — NOT NULL — 광고주 포인트 맵 아이디
  • Key (advertiserAcc_id) — INT — Foreign key → Copy Of influencer.Key — NOT NULL — 광고주 아이디
  • Key (point_id) — INT — Foreign key → Copy Of influencer2.Key — NOT NULL — 포인트 아이디
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field (created_by) — INT — NOT NULL — 생성자
  • Field2 (updated_at) — datetime — NOT NULL — 수정일시
  • Field3 (updated_by) — INT — NOT NULL — 수정자
  • Field (deleted_at) — datetime — NOT NULL — 삭제일시
  • Field (deleted_by) — INT — NOT NULL — 삭제자

Copy Of Copy Of Copy Of Copy Of influencer2 (campaignBoard)

  • Key (campaignBoard_id) — INT — Primary key — NOT NULL — 캠페인 보드 아이디
  • Key (advertiserAcc_id) — INT — Foreign key → Copy Of influencer.Key — NOT NULL — 광고주 아이디
  • Field (company_name) — VARCHAR(20) — NOT NULL — 업체명
  • Field (compaign_url) — VARCHAR(200) — NOT NULL — 업체 URL
  • Field2 (campaign_name) — VARCHAR(20) — NOT NULL — 캠페인 이름
  • Field (product_name) — VARCHAR(20) — NOT NULL — 상품명
  • Field (upload_period) — ENUM — NOT NULL — 업로드 기간(1주일,2주일,3주일,4주일)
  • Field (start_date) — datetime — NOT NULL — 시작일
  • Field2 (end_date) — datetime — NOT NULL — 종료일
  • Field (description) — VARCHAR(50) — 요구사항
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field2 (created_by) — INT — NOT NULL — 생성자
  • Field3 (updated_at) — datetime — NOT NULL — 수정일시
  • Field4 (updated_by) — INT — NOT NULL — 수정자
  • Field5 (deleted_at) — datetime — 삭제일시
  • Field6 (deleted_by) — INT — 삭제자

Copy Of Copy Of Copy Of Copy Of influencer222 (campaign_category_map)

  • Key (campaign_category_map_id) — INT — Primary key — NOT NULL — 캠페인 카테고리 맵 아이디
  • Key (category_id) — INT — Foreign key → Copy Of Copy Of influencer2.Key — NOT NULL — 카테고리 아이디
  • Key (campaign_id) — INT — Foreign key → Copy Of Copy Of Copy Of Copy Of influencer2.Key — NOT NULL — 캠페인 아이디
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field (created_by) — INT — NOT NULL — 생성자
  • Field2 (updated_at) — datetime — NOT NULL — 수정일시
  • Field3 (updated_by) — INT — NOT NULL — 수정자
  • Field (deleted_at) — datetime — NOT NULL — 삭제일시
  • Field (deleted_by) — INT — NOT NULL — 삭제자

Copy Of Copy Of Copy Of Copy Of influencer232 (influencerAcc_point_map)

  • Key (InfluencerAcc_point_map_id) — INT — Primary key — NOT NULL — 인플루언서 포인트 맵 아이디
  • Key (influencerAcc_id) — INT — Foreign key → influencer.Key — NOT NULL — 인플루언서 아이디
  • Key (point_id) — INT — Foreign key → Copy Of influencer2.Key — NOT NULL — 포인트 아이디
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field (created_by) — INT — NOT NULL — 생성자
  • Field2 (updated_at) — datetime — NOT NULL — 수정일시
  • Field3 (updated_by) — INT — NOT NULL — 수정자
  • Field (deleted_at) — datetime — NOT NULL — 삭제일시
  • Field (deleted_by) — INT — NOT NULL — 삭제자

Copy Of Copy Of Copy Of influencer2 (sns)

  • Key (sns_id) — INT — Primary key — NOT NULL — sns 아이디
  • Field2 (sns_name) — VARCHAR(10) — NOT NULL — sns 이름
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field2 (created_by) — INT — NOT NULL — 생성자
  • Field3 (updated_at) — datetime — NOT NULL — 수정일시
  • Field4 (updated_by) — INT — NOT NULL — 수정자
  • Field5 (deleted_at) — datetime — 삭제일시
  • Field6 (deleted_by) — INT — 삭제자

Copy Of Copy Of Copy Of influencer22 (influencer_category_map)

  • Key (influencerBoard_category_map_id) — INT — Primary key — NOT NULL — 인플루언서 보드 카테고리 맵 아이디
  • Key (influencerBoard_id) — INT — Foreign key → Copy Of influencer3.Key — NOT NULL — 인플루언서 보드 아이디
  • Key (category_id) — INT — Foreign key → Copy Of Copy Of influencer2.Key — NOT NULL — 카테고리 아이디
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field (created_by) — INT — NOT NULL — 생성자
  • Field2 (updated_at) — datetime — NOT NULL — 수정일시
  • Field3 (updated_by) — INT — NOT NULL — 수정자
  • Field (deleted_at) — datetime — NOT NULL — 삭제일시
  • Field (deleted_by) — INT — NOT NULL — 삭제자

Copy Of Copy Of influencer2 (category)

  • Key (category_id) — INT — Primary key — NOT NULL — 카테고리 아이디
  • Field2 (category_name) — VARCHAR(10) — NOT NULL — 카테고리 이름
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field (created_by) — INT — NOT NULL — 생성자
  • Field2 (updated_at) — datetime — NOT NULL — 수정일시
  • Field3 (updated_by) — INT — NOT NULL — 수정자
  • Field (deleted_at) — datetime — NOT NULL — 삭제일시
  • Field (deleted_by) — INT — NOT NULL — 삭제자

Copy Of influencer (advertiserAcc)

  • Key (advertiserAcc_id) — INT — Primary key — NOT NULL — 광고주 계정 아이디
  • Field (user_name) — VARCHAR(10) — NOT NULL — 사용자 이름
  • Field (company_name) — VARCHAR(20) — NOT NULL — 업체명 이름
  • Field (password) — VARCHAR(20) — NOT NULL — 비밀번호
  • Field2 (email) — VARCHAR(20) — NOT NULL — 이메일
  • Field (address) — VARCHAR(30) — NOT NULL — 주소
  • Field (phone) — VARCHAR(13) — NOT NULL — 휴대폰
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field3 (updated_at) — datetime — NOT NULL — 수정일시
  • Field4 (updated_by) — INT — NOT NULL — 수정자
  • Field5 (deleted_at) — datetime — 삭제일시
  • Field6 (deleted_by) — INT — 삭제자

Copy Of influencer2 (point)

  • Key (point_id) — INT — Primary key — NOT NULL — 포인트 아이디
  • Field (point_name) — VARCHAR(10) — NOT NULL — 포인트 이름
  • Field (totalPoint) — INT — 보유 포인트
  • Field (paymentMethod) — ENUM — 결제 방식(creditCard, bankTransfer, eWallet)
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field2 (created_by) — INT — NOT NULL — 생성자
  • Field3 (updated_at) — datetime — NOT NULL — 수정일시
  • Field4 (updated_by) — INT — NOT NULL — 수정자
  • Field5 (deleted_at) — datetime — 삭제일시
  • Field6 (deleted_by) — INT — 삭제자

Copy Of influencer3 (InfluencerBoard)

  • Key (influencerBoard_id) — INT — Primary key — NOT NULL — 인플루언서 보드 아이디
  • Key (influencerAcc_id) — INT — Foreign key → influencer.Key — NOT NULL — 인플루언서 계정 아이디
  • Field (channel_name) — VARCHAR(20) — NOT NULL — 채널명
  • Field3 (channel_url) — VARCHAR(200) — NOT NULL — 채널 URL
  • Field2 (subscriber) — INT — NOT NULL — 구독자 수
  • Field (description) — VARCHAR(50) — 특이사항
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field2 (created_by) — INT — NOT NULL — 생성자
  • Field3 (updated_at) — datetime — NOT NULL — 수정일시
  • Field4 (updated_by) — INT — NOT NULL — 수정자
  • Field5 (deleted_at) — datetime — 삭제일시
  • Field6 (deleted_by) — INT — 삭제자

influencer (influencerAcc)

  • Key (influencerAcc_id) — INT — Primary key — NOT NULL — 인플루언서 계정 아이디
  • Field2 (email) — VARCHAR(20) — NOT NULL — 이메일
  • Field3 (password) — VARCHAR(20) — NOT NULL — 비밀번호
  • Field (user_name) — VARCHAR(10) — NOT NULL — 사용자 이름
  • Field (phone) — VARCHAR(13) — NOT NULL — 휴대폰
  • Field (address) — VARCHAR(30) — NOT NULL — 주소
  • Field (description) — VARCHAR(50) — 특이사항
  • Field (created_at) — datetime — NOT NULL — 생성일시
  • Field3 (updated_at) — datetime — NOT NULL — 수정일시
  • Field4 (updated_by) — INT — NOT NULL — 수정자
  • Field5 (deleted_at) — datetime — 삭제일시
  • Field6 (deleted_by) — INT — 삭제자