2

Tables (5)

Card

  • ID — CHAR(6) — Primary key — NOT NULL
  • Owner — CHAR(6) — Foreign key → User.ID — NOT NULL
  • CreatedOwner — VARCHAR(20)
  • Title — VARCHAR(30) — NOT NULL
  • Category — "category" — NOT NULL
  • Tag — VARCHAR(30)
  • Field — JSONB
  • Description — TEXT
  • Created_At — TIMESTAMPTZ — NOT NULL
  • Updated_At — TIMESTAMPTZ — NOT NULL

Exchange

  • ID — CHAR(6) — Primary key — NOT NULL
  • Sale_ID — CHAR(6) — Foreign key → Sale.ID — NOT NULL
  • Offerer — CHAR(6) — Foreign key → User.ID — NOT NULL
  • Offer_Card_ID — CHAR(6) — Foreign key → Card.ID — NOT NULL
  • Message — VARCHAR(200)
  • Status — "exchange_status" — NOT NULL
  • Created_At — TIMESTAMPTZ — NOT NULL
  • Responded_At — TIMESTAMPTZ

Notification

  • ID — BIGSERIAL — Primary key — NOT NULL
  • User_ID — CHAR(6) — Foreign key → User.ID — NOT NULL
  • Type — VARCHAR(50) — NOT NULL
  • Content — TEXT — NOT NULL
  • Target_ID — CHAR(6)
  • Is_Read — BOOLEAN — NOT NULL
  • Created_At — TIMESTAMPTZ — NOT NULL

Sale

  • ID — CHAR(6) — Primary key — NOT NULL
  • Card_ID — CHAR(6) — Foreign key → Card.ID — NOT NULL
  • Seller — CHAR(6) — Foreign key → User.ID — NOT NULL
  • Title — VARCHAR(20)
  • Description — TEXT
  • Type — "sale_type" — NOT NULL
  • Status — "sale_status" — NOT NULL
  • Price — BIGINT
  • Wish_Category — "category"
  • Wish_Description — VARCHAR(200)
  • Created_At — TIMESTAMPTZ — NOT NULL
  • Updated_At — TIMESTAMPTZ — NOT NULL
  • Closed_At — TIMESTAMPTZ

User

  • ID — CHAR(6) — Primary key — NOT NULL
  • Nickname — VARCHAR(20) — NOT NULL
  • Email — VARCHAR(100)
  • Password — VARCHAR(255)
  • provider_id — VARCHAR(255)
  • provider — VARCHAR(50)
  • Point — BIGINT — NOT NULL
  • Image_Limit — INT — NOT NULL
  • Unread_Count — INT — NOT NULL
  • Last_Draw_At — TIMESTAMPTZ
  • Created_At — TIMESTAMPTZ — NOT NULL