DB TermProject

Tables (7)

ChatMessage (Untitled5)

  • message_id (Key) — Primary key — NOT NULL
  • sent_at (Field)
  • content (Field2)
  • is_read (Field3)
  • chatroom_id (Key2) — Foreign key → ChatRoom.chatroom_id — NOT NULL
  • sender_id (Key3) — Foreign key → Member.member_id — NOT NULL

ChatRoom (Untitled2)

  • chatroom_id (Key) — Primary key — NOT NULL
  • created_at (Field)
  • item_id (Key3) — Foreign key → Item.item_id — NOT NULL
  • buyer_id (Key4) — Foreign key → Member.member_id — NOT NULL
  • seller_id (Key2) — Foreign key → Member.member_id — NOT NULL

Item (Untitled)

  • item_id (Key) — Primary key — NOT NULL
  • description (Field)
  • category (Field2)
  • price (Field3)
  • preferred_place (Field4)
  • created_at (Field5)
  • sale_status (Field6)
  • member_id (Key2) — Foreign key → Member.member_id — NOT NULL

ItemImage (Untitled4)

  • image_id (Key) — Primary key — NOT NULL
  • image_url (Field)
  • image_order (Field2)
  • item_id (Field3)
  • item_id (Key2) — Foreign key → Item.item_id — NOT NULL

Member

  • member_id (Key) — Primary key — NOT NULL
  • password (Field)
  • nickname (Field2)
  • phone (Field3)
  • activity_region (Field4)

PurchaseRequest (Untitled3)

  • request_id (Key) — Primary key — NOT NULL
  • offered_price (Field)
  • request_message (Field2)
  • requested_at (Field3)
  • request_status (Field4)
  • buyer_id (Key2) — Foreign key → Member.member_id — NOT NULL
  • item_id (Key3) — Foreign key → Item.item_id — NOT NULL

Transaction (Untitled6)

  • transaction_id (Key) — Primary key — NOT NULL
  • approved_at (Field)
  • completed_at (Field2)
  • final_price (Field3)
  • transaction_status (Field4)
  • request_id (Key2) — Foreign key → PurchaseRequest.request_id — NOT NULL
  • item_id (Key3) — Foreign key → Item.item_id — NOT NULL