chagok

테이블 (17)

결제 (payments)

  • payment_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id (Key3) — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • order_id (Field) — VARCHAR — NOT NULL
  • order_name (Field2) — VARCHAR — NOT NULL
  • price (Field3) — INT — NOT NULL
  • status (Field6) — VARCHAR — NOT NULL
  • created_at (Field4) — TIMESTAMP — NOT NULL
  • updated_at (Field5) — TIMESTAMP — NOT NULL

관리자 (admin)

  • admin_id (Key) — BIGINT — 기본 키 — NOT NULL
  • login_id (Field) — VARCHAR — NOT NULL
  • password (Field2) — VARCHAR — NOT NULL
  • role (Field3) — VARCHAR — NOT NULL

구독 (memberships)

  • membership_id (Key2) — BIGINT — 기본 키 — NOT NULL
  • billing_info_id (Key3) — VARCHAR — 외래 키 → 정기결제 정보.billing_info_id — NOT NULL
  • user_id (Key) — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • plan_type (Field) — VARCHAR — NOT NULL
  • start_date (Field2) — TIMESTAMP — NOT NULL
  • end_date (Field3) — TIMESTAMP — NOT NULL
  • price (Field4) — INT — NOT NULL

사용자 (users)

  • user_id (Key) — BIGINT — 기본 키 — NOT NULL
  • oauth_id (Key2) — BIGINT — 외래 키 → 소셜.oauth_id — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • email (Field2) — VARCHAR — NOT NULL
  • gender (Field10) — VARCHAR — NOT NULL
  • birth_date (Field3) — DATE — NOT NULL
  • profile_image (Field4) — VARCHAR
  • tendency (Field5) — INT — NOT NULL
  • active (Field6) — VARCHAR — NOT NULL
  • point (Field9) — BIGINT — NOT NULL
  • created_at (Field7) — TIMESTAMP — NOT NULL
  • updated_at (Field8) — TIMESTAMP — NOT NULL

사용자 습관 (user_habit)

  • user_action_id (Key3) — BIGINT — 기본 키 — NOT NULL
  • user_id (Key) — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • habit_id (Key2) — BIGINT — 외래 키 → 습관.habit_id — NOT NULL
  • start_date (Field) — DATE — NOT NULL
  • end_date (Field2) — DATE — NOT NULL
  • is_public (Field3) — VARCHAR — NOT NULL
  • state (Field4) — VARCHAR — NOT NULL
  • created_at (Field5) — TIMESTAMP — NOT NULL
  • updated_at (Field6) — TIMESTAMP — NOT NULL

사용자 행위 (user_action)

  • user_action_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id (Key5) — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • habit_id (Key4) — BIGINT — 외래 키 → 습관.habit_id — NOT NULL
  • action_id (Key2) — BIGINT — 외래 키 → 행위.action_id — NOT NULL
  • user_habit_id (Key3) — BIGINT — 외래 키 → 사용자 습관.user_action_id — NOT NULL
  • action_date (Field) — TIMESTAMP — NOT NULL
  • is_completed (Field2) — VARCHAR — NOT NULL
  • delay_count (Field3) — INT
  • created_at (Field4) — TIMESTAMP — NOT NULL
  • updated_at (Field5) — TIMESTAMP — NOT NULL

사용자 행위 인증 (action_verify)

  • user_action_id (Key) — BIGINT — 외래 키 → 사용자 행위.user_action_id — NOT NULL
  • check_method_id (Key2) — BIGINT — 외래 키 → 인증 방식.check_method_id — NOT NULL
  • verify_date (Field) — TIMESTAMP — NOT NULL
  • value (Field3) — VARCHAR — NOT NULL
  • method_order (Field2) — INTEGER — NOT NULL

사용자보유상품 (user_item)

  • user_id (Key) — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • item_id (Key2) — BIGINT — 외래 키 → 상품.item_id — NOT NULL
  • count (Field) — BIGINT — NOT NULL

상품 (item)

  • item_id (Key) — BIGINT — 기본 키 — NOT NULL
  • item_name (Field) — VARCHAR — NOT NULL
  • img_url (Field2) — VARCHAR
  • description (Field3) — VARCHAR
  • price (Field4) — INTEGER — NOT NULL

소셜 (oauth)

  • oauth_id (Key) — BIGINT — 기본 키 — NOT NULL
  • social_provider (Field) — VARCHAR — NOT NULL
  • social_id (Field2) — VARCHAR — NOT NULL

스트릭 (streak)

  • user_id (Key) — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • streak (Field) — INTEGER — NOT NULL
  • isFreaze (Field2) — VARCHAR — NOT NULL

습관 (habit)

  • habit_id (Key) — BIGINT — 기본 키 — NOT NULL
  • category (Field8) — INTEGER — NOT NULL
  • title (Field) — VARCHAR — NOT NULL
  • frequency (Field4) — INT — NOT NULL
  • freq_unit (Field5) — INT — NOT NULL
  • freq_count (Field7) — INT — NOT NULL
  • is_template (Field2) — VARCHAR — NOT NULL
  • created_at (Field3) — TIMESTAMP — NOT NULL
  • updated_at (Field6) — TIMESTAMP — NOT NULL
  • valid_start_at (Field9) — TIMESTAMP — NOT NULL
  • valid_end_at (Field10) — TIMESTAMP — NOT NULL
  • image (Field11) — VARCHAR
  • owner_id (Field12) — LONG
  • origin_habit_id (Field13) — LONG

인증 방식 (check_method)

  • check_method_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id (Key2) — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • title (Field) — VARCHAR — NOT NULL
  • created_at (Field2) — TIMESTAMP — NOT NULL
  • updated_at (Field3) — TIMESTAMP — NOT NULL
  • valid_start_at (Field4) — TIMESTAMP — NOT NULL
  • valid_end_at (Field5) — TIMESTAMP — NOT NULL

인증 방식 세부 (check_method_detail)

  • check_method_id (PK) — BIGINT — 외래 키 → 인증 방식.check_method_id — NOT NULL
  • method_order (Key) — INTEGER — NOT NULL
  • type (Field2) — VARCHAR — NOT NULL
  • value (Field3) — VARCHAR — NOT NULL
  • valid_start_at (Field4) — TIMESTAMP — NOT NULL
  • valid_end_at (Field5) — TIMESTAMP — NOT NULL

정기결제 정보 (billing_info)

  • billing_info_id (Key) — VARCHAR — 기본 키 — NOT NULL
  • billing_key (Field2) — VARCHAR — NOT NULL
  • expired_at (Field) — TIMESTAMP
  • created_at (Field3) — TIMESTAMP — NOT NULL
  • updated_at (Field4) — TIMESTAMP — NOT NULL

포인트구매내역 (purchase_history)

  • purchase_history_id (Key) — BIGINT — 기본 키 — NOT NULL
  • user_id (Key2) — BIGINT — 외래 키 → 사용자.user_id — NOT NULL
  • item_id (Key3) — BIGINT — 외래 키 → 상품.item_id — NOT NULL
  • count (Field) — INTEGER — NOT NULL
  • history_state (Field2) — VARCHAR — NOT NULL

행위 (action)

  • action_id (Key) — BIGINT — 기본 키 — NOT NULL
  • habit_id (Key2) — BIGINT — 외래 키 → 습관.habit_id — NOT NULL
  • check_method_id (Key3) — BIGINT — 외래 키 → 인증 방식.check_method_id — NOT NULL
  • sequence (Field) — INT — NOT NULL
  • content (Field2) — VARCHAR
  • freq_seq (Field5) — INT — NOT NULL
  • created_at (Field4) — TIMESTAMP — NOT NULL
  • updated_at (Field6) — TIMESTAMP — NOT NULL
  • valid_start_at (Field3) — TIMESTAMP — NOT NULL
  • valid_end_at (Field7) — TIMESTAMP — NOT NULL