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)