d
Tables (4)
chatroom
- room_id (room_od) — INT — Primary key — NOT NULL
- receiver_id — INT — NOT NULL
- sender_id — INT — NOT NULL
- product_id — INT
message
- receiver_id — INT — Primary key — NOT NULL
- sender_id — INT — Primary key — NOT NULL
- Key — Foreign key → user.Key — NOT NULL
- product_id (Key2) — INT — Foreign key → product.product_id — NOT NULL
- room_id (room_od) — INT — Foreign key → chatroom.room_id — NOT NULL
- content — TEXT
product
- product_id (Key) — INT — Primary key — NOT NULL
- owner_id — INT — NOT NULL
- product_name — VARCHAR(50) — NOT NULL
- price — INT — NOT NULL
- status — VARCHAR(50) — NOT NULL
- datetime — DATE
- description — TEXT
user
- Key — Primary key — NOT NULL
- user_id — INT
- email — VARCHAR(50) — NOT NULL
- pwd — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(50) — NOT NULL
- name — VARCHAR(50) — NOT NULL