pickle-plus-clone-backend

Tables (7)

Banks (Untitled5)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • fk_user_id (Key2) — INTEGER — Foreign key → Users.id — NOT NULL
  • bank_name (은행이름) — STRING
  • bank_account (계좌번호) — STRING

Cards (Untitled4)

  • id (Key) — integer — Primary key — NOT NULL
  • fk_user_id (Key2) — integer — Foreign key → Users.id — NOT NULL
  • card_token (Field) — string

Followers (Untitled3)

  • fk_party_id (Key) — integer — Foreign key → Party.id — NOT NULL
  • fk_user_id (파티장) — integer — Foreign key → Party.fk_user_id — NOT NULL
  • nick_name (별명) — string
  • created_at (Field) — date
  • updated_at (Field2) — date
  • Field3

Membership (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • fk_user_id (Key2) — Foreign key → Users.id — NOT NULL
  • membership_type (구독권 종류) — integer(enum설정)
  • created_at (시작일) — date
  • updated_at (변경일) — date
  • deleted_at (종료일) — date

Party (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • fk_user_id (파티장) — integr — Foreign key → Users.id — NOT NULL
  • party_type (넷플릭스, 웨이브, 왓챠) — integer(enum설정)
  • party_id (넷플릭스 아이디) — string
  • party_password (넷플릭스 비번) — string
  • nick_name (별명) — string
  • createdAt (Field) — date
  • updateda (Field2) — date
  • Field3

Payments (Untitled6)

  • id (Key) — integer — Primary key — NOT NULL
  • fk_user_id (Key2) — integer — Foreign key → Users.id — NOT NULL
  • created_at (결제일) — date
  • updated_at (Field) — date
  • payment_check (결제여부 확인) — boolean

Users (Untitled)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • name (Field) — string
  • password (Field5) — string
  • email (Field2) — string
  • kakao_token (Field3) — string
  • createdAt (Field4) — date
  • updatedAt (Field6) — date