hyosang
Tables (6)
cart (CopyOfUntitled4)
- cart_id (PK) — INT — Primary key — NOT NULL
- user_id (FK_user_id) — VARCHAR(20)
- created_at (Field) — DATETIME
- Field2
cart_item (Untitled2)
- cart_item_id (PK) — INT — Primary key — NOT NULL
- product_id (FK_product_id) — INT
- price (DECIMAL) — DECIMAL(10,2)
- added_at (Field) — DATETIME
- cart_id (PK2) — INT — Foreign key → cart.cart_id — NOT NULL
category (CopyOfUntitled3)
- category_id (Key) — Primary key — NOT NULL
- parent_id (Field)
- name (Field2)
- level (Field3)
chat_message (Untitled)
- chat_message_id (Key) — Primary key — NOT NULL
- sender_id (FK_user_id)
- chat_room_id (Key2) — INT — Foreign key → chat_room.chat_room_id — NOT NULL
- sender_role (Field) — VARCHAR(20)
- Field2
chat_room (CopyOfUntitled)
- chat_room_id (Key) — Primary key — NOT NULL
- user_id (Field)
- admin_id (Field3) — VARCHAR(20)
- created_at (Field4) — DATETIME
- updated_at (J) — DATETIME
file (CopyOfUntitled2)
- file_id (Key) — Primary key — NOT NULL
- ref_type (Field)
- ref_id (Field2)
- ofname (Field3)
- fname (Field4)
- fpath (Field5)
- fsize (Field6)
- ftype (Field7)