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