당근마켓 erd
테이블 (6)
Category (category)
- category_id (PK) — bigint — 기본 키 — NOT NULL
- item_id (FK) — bigint — 기본 키
- category_id (FK2) — varchar(20) — 기본 키
- name (Field) — varchar(30)
- price (Field2) — bigint
- item_id (PK2) — bigint — 외래 키 → Item.item_id — NOT NULL
- item_id (PK3) — bigint — 외래 키 → Item.item_id — NOT NULL
- category (FK23) — bigint — 외래 키 → Item.category
- Chat_id (PK4) — bigint — 외래 키 → Item.Chat_id — NOT NULL
Chat (chats)
- Chat_id (PK) — bigint — 기본 키 — NOT NULL
- item (FK) — bigint
- sender (FK2) — bigint
- receiver (Fk3) — bigint
- content (Field) — text
- timestamp (Field2) — timestamp
- last_message (Field3) — one to on
- user_id (PK2) — bigint — 외래 키 → User.user_id — NOT NULL
- trans_id (PK22) — bigint — 외래 키 → User.trans_id — NOT NULL
Image (images)
- image_id (PK) — bigint — 기본 키 — NOT NULL
- item_id (FK) — bigint
- images (Field) — imagefield
- item_id (PK2) — bigint — 외래 키 → Item.item_id — NOT NULL
- Chat_id (PK4) — bigint — 외래 키 → Item.Chat_id — NOT NULL
Item (items)
- item_id (PK) — bigint — 기본 키 — NOT NULL
- Chat_id (PK4) — bigint — 외래 키 → Chat.Chat_id — NOT NULL
- seller_name (FK) — bigint
- category (FK2) — bigint
- upload_date (Field) — timestamp
- title (Field2) — varchar(70)
- content (Field3) — text
- price (Field4) — bigint
- hope_loc (Field5) — varchar(40)
- views (Field6) — bigint
- image_url (Field7) — varchar(200)
- chat_count (Field8) — bigint
- is_end (Field9) — boolean
- user_id (PK2) — bigint — 외래 키 → User.user_id — NOT NULL
- trans_id (PK3) — bigint — 외래 키 → Transaction.trans_id — NOT NULL
- trans_id (PK22) — bigint — 외래 키 → User.trans_id — NOT NULL
Transaction (transactions)
- trans_id (PK) — bigint — 기본 키 — NOT NULL
- buyer_name (FK) — bigint
- item_id (FK2) — bigint
User (users)
- user_id (PK) — bigint — 기본 키 — NOT NULL
- trans_id (PK2) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(20)
- password (Field2) — varchar(20)
- region (Field3) — varchar(30)
- trans_id (PK3) — bigint — 외래 키 → Transaction.trans_id — NOT NULL