aaa
Tables (12)
book
- id — INT
- isbn — VARCHAR(13) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(255) — NOT NULL
- publisher — VARCHAR(255)
- publication_date — DATE
- category_id — INT
category
- id — INT
- name — VARCHAR(100) — NOT NULL
- parent_id — INT
- created_at — DATETIME
chatting
- id — INT
- room_id — INT
- send_user_id — INT
- message — TEXT
- is_read — BOOLEAN
- created_at — DATETIME
chatting_room
- id — INT
- identifier — VARCHAR(100) — NOT NULL
- last_chat — TEXT
- created_at — DATETIME
favorite_product
- member_id) — REFERENCES
- member_id — INT
- product_id — INT
- review_text — TEXT
- rating — INT
- created_at — DATETIME
member
- id — INT
- userid — VARCHAR(20) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50)
- birth_date — DATE — NOT NULL
- gender — ENUM('male', 'female', 'other')
- is_admin — BOOLEAN
- created_at — DATETIME
- is_deleted — BOOLEAN
- deleted_at — DATETIME
- agree — BOOLEAN
notification
- id — INT
- member_id — INT
- message — TEXT
- is_read — BOOLEAN
- created_at — DATETIME
orders
- id — INT
- member_id — INT
- product_id — INT
- quantity — INT — NOT NULL
- order_status — ENUM('Pending', 'Completed', 'Cancelled', 'Refunded')
- created_at — DATETIME
participant
- id — INT
- room_id — INT
- user_id — INT
payment
- id — INT
- product_id — INT
- order_id — INT
- quantity — INT — NOT NULL
- street_address — VARCHAR(255)
- detail_address — VARCHAR(255)
- created_at — DATETIME
product
- id — INT
- book_id — INT — NOT NULL
- member_id — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- book_condition — ENUM
- trade_method — VARCHAR(100)
- payment_location — VARCHAR(255)
- description — TEXT
- created_at — DATETIME
- product_status — ENUM('Deleted','For Sale', 'Reserved', 'Sold Out')
- # — product_status
- book_image — VARCHAR(255)
report
- id — INT
- member_id — INT
- product_id — INT
- report_reason — TEXT
- created_at — DATETIME