tritai

Tables (6)

Campaign (캠페인)

  • id (pk) — Primary key — NOT NULL
  • company_id (fk) — Foreign key → company.id — NOT NULL
  • title (타이틀)
  • brandname (캠페인이름)
  • image (썸네일이미지)
  • application_start (신청기간_시작)
  • application_end (신청기간_종료)
  • selection_start (선정_시작)
  • selection_end (선정_종료)
  • announcement (크리에이터발표)
  • result_announcement (캠페인 결과 발표)
  • people (모집 인원)
  • video_min (비디오_최소길이)
  • video_maxs (비디오_최대길이)
  • sns (sns 업로드 목록)
  • mission_text (미션내용)
  • product_detail (상품상세설명)
  • reward_creditr (리워드_키워드)
  • reward_additional (추가리워드)
  • notes (유의사항)
  • location (방문 위치 정보)
  • open_time (운영 시간)
  • visit_time (방문 시간)
  • status (상태)
  • create_at (Field22)

Content (게시글)

  • id (pk) — Primary key — NOT NULL
  • user_Id (fk) — Foreign key → User.id — NOT NULL
  • post_number (게시글번호)
  • title (제목)
  • url (sns주소)
  • created_at (작성시각)
  • views (조회수)
  • likes (좋아요)
  • category (카테고리) — enum
  • location (위치)
  • latitude (위도)
  • longitude (경도)
  • hashtags (해시태그)
  • description (상세설명)
  • vidieo (비디오)
  • image (이미지)

Creator (크리에이터)

  • id (pk) — Primary key — NOT NULL
  • user_id (fk) — Foreign key → User.id — NOT NULL
  • category (카테고리)
  • youtube (유튜브주소)
  • instagram (인스타주소)
  • tiktok (틱톡주소)
  • introduction (한줄소개)

User (회원)

  • id (pk) — Primary key — NOT NULL
  • login_id (아이디)
  • password (비밀번호)
  • nickname (닉네임)
  • gender (성별)
  • profilimage (프로필사진)
  • phone_number (핸드폰번호)
  • address (주소)
  • birthday (생일)
  • nationality (국적)
  • user_role (역할) — enum

caompainn_apply (캠페인신청)

  • pk — Primary key — NOT NULL
  • creator_id (fk) — Foreign key → Creator.id — NOT NULL
  • name (이름)
  • email (이메일)
  • phone (핸드폰번호)
  • birthday (생년월일)
  • gender (성별)
  • instagram (인스타주소)
  • youtube (유튜브주소)

company (업체)

  • id (pk) — Primary key — NOT NULL
  • user_id (fk) — Foreign key → User.id — NOT NULL
  • category (카테고리)
  • introduction (한줄소개)
  • company_name (회사이름)
  • company_sns (회사sns)