당근마켓
테이블 (14)
active_areas (Untitled10)
- area_id (Key) — 외래 키 → areas.id — NOT NULL
- user_id (id) — 외래 키 → users.user_id — NOT NULL
- activated (Field)
- created_at (Field2)
- updated_at (Field3)
- Field4
areas (Untitled9)
- id (Key) — 기본 키 — NOT NULL
- address (Field)
- zip_code (Field2)
- created_at (Field3)
- updated_at (Field4)
chat_messages (Untitled8)
- id — 기본 키 — NOT NULL
- sender_id — 기본 키 — NOT NULL
- chat_room_id — 외래 키 → chat_rooms.id — NOT NULL
- content
- read_or_not
- created_at
chat_rooms (Untitled7)
- id — 기본 키 — NOT NULL
- seller_id — 외래 키 → products.product_id — NOT NULL
- buyer_id — 외래 키 → users.user_id — NOT NULL
- activated
- created_at
follow_users (Untitled4)
- follow_users_id — 기본 키 — NOT NULL
- activated
- created_at
- updated_at
manner_evaluation (Untitled13)
- id (Key) — 기본 키 — NOT NULL
- user_id (id) — 외래 키 → users.user_id — NOT NULL
- score (Field)
- created_at (Field2)
notification_keywords (Untitled12)
- id (Key) — 기본 키 — NOT NULL
- user_id (id) — 외래 키 → users.user_id — NOT NULL
- name (Field)
- activated (Field2)
- created_at (Field3)
- updated_at (Field4)
notifications (Untitled11)
- id (Key) — 기본 키 — NOT NULL
- user_id (id) — 외래 키 → users.user_id — NOT NULL
- title (Field)
- content (Field2)
- type (Field3)
- read_or_not (Field4)
- created_at (Field5)
products (Untitled3)
- product_id (seller_id) — 기본 키 — NOT NULL
- user_id — 외래 키 → users.user_id — NOT NULL
- title
- price
- content
- status
- view_count
- created_at
- updated_at
- refreshed_at
products_categories (Untitled6)
products_images (Untitled5)
- seller_id — 외래 키 → products.product_id — NOT NULL
- image_url
reviews (Untitled14)
- id (Key) — 기본 키 — NOT NULL
- buyer_id (Field)
- content (Field2)
- created_at (Field3)
users (Users)
- user_id — string — 기본 키 — NOT NULL
- phone_number
- nickname
- manner_rate
- activated
- created_at
- updated_at
users_images (Untitled2)
- users_images_id — 외래 키 → users.user_id — NOT NULL
- image_url