SoloProject

Tables (9)

Category (카테고리)

  • category_id (카테고리ID) — NOT NULL — Primary key — NOT NULL
  • category_name (카테고리이름) — NOT NULL
  • category_image (카테고리 이미지) — NOT NULL

Member (회원)

  • member_id (회원ID) — NOT NULL — Primary key — NOT NULL
  • name (이름) — NOT NULL
  • email (이메일) — NOT NULL
  • password (비밀번호) — NOT NULL
  • gender (성별) — NOT NULL
  • age (나이) — NOT NULL
  • phone_number (휴대폰번호) — NOT NULL
  • create_at (가입날짜) — NOT NULL
  • modified_at (수정날짜) — NOT NULL
  • member_status (회원상태) — NOT NULL
  • image (프로필이미지) — NOT NULL

Notification (알림)

  • notification_id (알림id) — NOT NULL — Primary key — NOT NULL
  • subs_id (구독id) — NOT NULL — Foreign key → Subs.subs_id — NOT NULL
  • notify_days_before (알림기준) — NOT NULL
  • scheduled_at (알림시간) — NOT NULL
  • is_sent (전송여부) — NOT NULL
  • create_at (설정날짜) — NOT NULL

Platform (플랫폼)

  • platform_id (플랫폼id) — NOT NULL — Primary key — NOT NULL
  • category_id (카테고리ID) — NOT NULL — Foreign key → Category.category_id — NOT NULL
  • platform_name (플랫폼명) — NOT NULL
  • service_at (서비스 시작날짜) — NOT NULL
  • platform_image (플랫폼 이미지) — NOT NULL
  • rating_avg (평균별점) — NOT NULL
  • description (플랫폼 설명) — NOT NULL
  • review_cnt (리뷰 수) — NOT NULL

Recommend (추천)

  • recommend_id (추천id) — NOT NULL — Primary key — NOT NULL
  • member_id (회원ID) — NOT NULL — Foreign key → Member.member_id — NOT NULL
  • review_id (리뷰ID) — NOT NULL — Foreign key → Review.review_id — NOT NULL

Review (리뷰)

  • review_id (리뷰id) — NOT NULL — Primary key — NOT NULL
  • platform_id (플랫폼id) — NOT NULL — Foreign key → Platform.platform_id — NOT NULL
  • member_id (회원ID) — NOT NULL — Foreign key → Member.member_id — NOT NULL
  • content (본문) — NOT NULL
  • rating (별점) — NOT NULL
  • create_at (작성날짜) — NOT NULL
  • modified_at (수정날짜) — NOT NULL
  • Recommend_cnt (추천 수) — NOT NULL

Role (권한)

  • role (권한) — NOT NULL — Primary key — NOT NULL
  • member_id (회원ID) — NOT NULL — Foreign key → Member.member_id — NOT NULL

Subs (구독)

  • subs_id (구독id) — NOT NULL — Primary key — NOT NULL
  • subs_paln_id (구독플랜id) — NOT NULL — Foreign key → Subs_Plan.subs_paln_id — NOT NULL
  • member_id (회원ID) — NOT NULL — Foreign key → Member.member_id — NOT NULL
  • create_at (등록날짜) — NOT NULL
  • update_at (수정날짜) — NOT NULL
  • subs_status (구독상태) — NOT NULL
  • subs_at (구독시작날짜) — NOT NULL
  • next_payment_date (다음결제일) — NOT NULL

Subs_Plan (구독 플랜)

  • subs_paln_id (구독플랜id) — NOT NULL — Primary key — NOT NULL
  • platform_id (플랫폼id) — NOT NULL — Foreign key → Platform.platform_id — NOT NULL
  • price (요금) — NOT NULL
  • plan_name (구독플랜 명) — NOT NULL
  • billing_cycle (결제주기) — NOT NULL