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