JQdSQA2n8zuu

Viral DB

Tables (9)

fans (Untitled4)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL — AUTO_INCREMENT
  • user_id (Key2) — INT UNSIGNED — Foreign key → users.id — NOT NULL — AUTO_INCREMENT
  • plan_id (Key3) — INT UNSIGNED — Foreign key → plans.id — NOT NULL — AUTO_INCREMENT
  • picture (Field) — TEXT — NOT NULL — 카드 프로필 이미지
  • number (Field2) — INT UNSIGNED — NOT NULL — ZEROFILL maybe
  • display (Field6) — BOOLEAN — NOT NULL
  • created_at (Field3) — TIMESTAMP — NOT NULL
  • updated_at (Field4) — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP
  • deleted_at (Field5) — TIMESTAMP

links (Untitled2)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL — AUTO_INCREMENT
  • user_id (Key2) — INT UNSIGNED — Foreign key → users.id — NOT NULL — AUTO_INCREMENT
  • type (Field2) — TEXT — SNS link, Text & Picture Link
  • items (Field) — JSON — NOT NULL — [{ "url": string, "text": string(optional), "picture": string(optional), }]
  • created_at (Field3) — TIMESTAMP — NOT NULL
  • updated_at (Field4) — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP

logs (Untitled8)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL — AUTO_INCREMENT
  • user_id (Key2) — INT UNSIGNED — Foreign key → users.id — NOT NULL — AUTO_INCREMENT
  • data (Field) — LONGTEXT — NOT NULL — All of activities of the user
  • created_at (Field2) — TIMESTAMP — NOT NULL
  • updated_at (Field3) — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP

orders (Untitled6)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL — AUTO_INCREMENT
  • fan_id (Key2) — INT UNSIGNED — Foreign key → fans.id — NOT NULL — AUTO_INCREMENT
  • type (Field6) — TEXT — NOT NULL
  • order_id (Field2) — TEXT — NOT NULL — Order ID of each recurring payment
  • paid (Field) — INT UNSIGNED — NOT NULL — Sum of paid amount
  • created_at (Field3) — TIMESTAMP — NOT NULL
  • updated_at (Field4) — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP
  • deleted_at (Field5) — TIMESTAMP

payments (Untitled7)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL — AUTO_INCREMENT
  • order_id (Key2) — INT UNSIGNED — Foreign key → orders.id — NOT NULL — AUTO_INCREMENT
  • raw (Field9) — LONGTEXT — NOT NULL — Raw data of the payment
  • type (Field) — TEXT
  • payment_id (Field2) — TEXT — NOT NULL — Payment ID of each payment
  • paid (Field3) — INT UNSIGNED — NOT NULL — Actual paid JPY including fees
  • fee (Field5) — INT UNSIGNED — NOT NULL — JPY fee of the payment
  • created_at (Field6) — TIMESTAMP — NOT NULL
  • updated_at (Field7) — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP
  • deleted_at (Field8) — TIMESTAMP

plans (Untitled5)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL — AUTO_INCREMENT
  • user_id (Key2) — INT UNSIGNED — Foreign key → users.id — NOT NULL — AUTO_INCREMENT
  • type (Field) — TEXT — NOT NULL
  • name (Field7) — TEXT — NOT NULL
  • price (Field2) — INT UNSIGNED — NOT NULL
  • color (Field3) — TEXT — NOT NULL
  • background_image (Field6) — TEXT
  • created_at (Field4) — TIMESTAMP — NOT NULL
  • updated_at (Field5) — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP

sns (Untitled10)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL — AUTO_INCREMENT
  • user_id (Key2) — INT UNSIGNED — Foreign key → users.id — NOT NULL — AUTO_INCREMENT
  • platform (Field) — TEXT — NOT NULL
  • username (Field2) — TEXT — NOT NULL — https://www.facebook.com/[id] https://www.instagram.com/[id] ...
  • created_at (Field3) — TIMESTAMP — NOT NULL
  • updated_at (Field4) — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP

themes (Untitled3)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL — AUTO_INCREMENT
  • text_color (Field) — TEXT — NOT NULL — 추후에 상세하게 표시
  • background_color (Field4) — TEXT — NOT NULL
  • primary_color (Field5) — TEXT — NOT NULL
  • secondary_color (Field6) — TEXT — NOT NULL
  • created_at (Field2) — TIMESTAMP — NOT NULL
  • updated_at (Field3) — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP

users (Untitled)

  • id (Key) — INT UNSIGNED — Primary key — NOT NULL — AUTO_INCREMENT
  • theme_id (Key2) — INT UNSIGNED — Foreign key → themes.id — NOT NULL — AUTO_INCREMENT
  • email (Field) — TEXT — NOT NULL
  • type (Field6) — TEXT — NOT NULL
  • username (Field2) — TEXT — vir.jp/@username
  • name (Field12) — TEXT — Name of the user
  • picture (Field10) — TEXT — User profile image
  • description (Field11) — LONGTEXT — User description
  • fanclub_enabled (Field7) — BOOLEAN — NOT NULL
  • level (Field8) — INT UNSIGNED — NOT NULL
  • point (Field9) — INT UNSIGNED — NOT NULL
  • created_at (Field3) — TIMESTAMP — NOT NULL
  • updated_at (Field4) — TIMESTAMP — NOT NULL — ON UPDATE CURRENT_TIMESTAMP
  • deleted_at (Field5) — TIMESTAMP — Soft Delete