최애멍냥
테이블 (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