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