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)