최애멍냥

테이블 (6)

Card

  • ID — CHAR(6) — 기본 키 — NOT NULL
  • Owner — CHAR(6) — 외래 키 → User.ID — NOT NULL
  • CreatedOwner — VARCHAR(20) — 외래 키 → User.ID — NOT NULL
  • Name — VARCHAR(30) — NOT NULL
  • Category — "category" 고양이, 강아지 — NOT NULL
  • Image — TEXT
  • FilterType — SMALLINT
  • Tag — VARCHAR(30)
  • Score — JSONB
  • TopScore — INT
  • Description — TEXT
  • Created_At — TIMESTAMPTZ — NOT NULL
  • Updated_At — TIMESTAMPTZ — NOT NULL

Exchange

  • ID — CHAR(6) — 기본 키 — NOT NULL
  • Sale_ID — CHAR(6) — 외래 키 → Sale.ID — NOT NULL
  • Offerer — CHAR(6) — 외래 키 → User.ID — NOT NULL
  • Offer_Card_ID — CHAR(6) — 외래 키 → Card.ID — NOT NULL
  • Message — VARCHAR(200)
  • Status — "exchange_status" (수락, 거절, 대기, 취소) — NOT NULL
  • Created_At — TIMESTAMPTZ — NOT NULL
  • Responded_At — TIMESTAMPTZ

Notification

  • ID — BIGSERIAL — 기본 키 — NOT NULL
  • User_ID — CHAR(6) — 외래 키 → 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) — 기본 키 — NOT NULL
  • Card_ID — CHAR(6) — 외래 키 → Card.ID — NOT NULL
  • Seller — CHAR(6) — 외래 키 → User.ID — NOT NULL
  • Description — TEXT
  • CanExchange — BOOLEAN — NOT NULL
  • Status — "sale_status" (onSale, onExchange, Soldout, Cancled, Exchanged) — NOT NULL
  • Price — BIGINT
  • Created_At — TIMESTAMPTZ — NOT NULL
  • Updated_At — TIMESTAMPTZ — NOT NULL
  • Closed_At — TIMESTAMPTZ

User

  • ID — CHAR(6) — 기본 키 — NOT NULL
  • Nickname — VARCHAR(20) — NOT NULL
  • Point — BIGINT — NOT NULL
  • Last_Draw_At — TIMESTAMPTZ
  • Created_At — TIMESTAMPTZ — NOT NULL

User_Auth

  • ID — BIGSERIAL — 기본 키 — NOT NULL
  • User_ID — CHAR(6) — 외래 키 → User.ID — NOT NULL
  • Provider — VARCHAR(50) — NOT NULL
  • Provider_UID — VARCHAR(255) — NOT NULL
  • Password — VARCHAR(255)
  • Created_At — TIMESTAMPTZ — NOT NULL