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