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 — 삭제자