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