joolang

Tables (14)

Bug_Report (Untitled12)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • title (Field) — NOT NULL
  • content (Field2) — NULL
  • User_id (Key2) — NOT NULL — Foreign key → User.id — NOT NULL

Chat (Untitled5)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • User_id (Key2) — NOT NULL — Foreign key → User.id — NOT NULL

Chat_List (Untitled6)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • user_chat (Field) — NOT NULL
  • other_chat (Field2) — NOT NULL
  • chat_time (Field3) — NOT NULL
  • Chat_id (Key2) — NOT NULL — Foreign key → Chat.id — NOT NULL

Complain (Untitled14)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • title (Field) — NOT NULL
  • content (Field2) — NULL
  • Product_id (Key2) — NOT NULL — Foreign key → Product.id — NOT NULL

Dibs (Untitled9)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • User_id (Key2) — NOT NULL — Foreign key → User.id — NOT NULL

Get_List (Untitled11)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • User_id (Key2) — NOT NULL — Foreign key → User.id — NOT NULL

Give_List (Untitled10)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • User_id (Key2) — NOT NULL — Foreign key → User.id — NOT NULL

Location (Untitled7)

  • id — NOT NULL — Primary key — NOT NULL
  • address (Field) — NOT NULL
  • detail_address (Field2) — NOT NULL
  • postnumber (Field3) — NOT NULL
  • User_id (id2) — NOT NULL — Foreign key → User.id — NOT NULL

Maner_Level (Untitled13)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • score (Field) — NOT NULL
  • User_id (Key2) — NOT NULL — Foreign key → User.id — NOT NULL

Product (Untitled2)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — NOT NULL
  • content (Field2) — NULL
  • upload_time (Field4) — NOT NULL
  • User_id (Key2) — NOT NULL — Foreign key → User.id — NOT NULL
  • Product_Display_id (Key3) — NOT NULL — Foreign key → Product_Display.id — NOT NULL

Product_Display (Untitled4)

  • id (Key) — NOT NULL — Primary key — NOT NULL

Product_picture (Untitled3)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • picture_url (Field) — NULL
  • Product_id (Key2) — NOT NULL — Foreign key → Product.id — NOT NULL
  • Product_Display_id (Key3) — NOT NULL — Foreign key → Product_Display.id — NOT NULL

Teg (Untitled8)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • teg (Field) — NOT NULL
  • Product_id (Key2) — NOT NULL — Foreign key → Product.id — NOT NULL
  • Product_Display_id (Key3) — NOT NULL — Foreign key → Product_Display.id — NOT NULL

User (Untitled)

  • id — NOT NULL — Primary key — NOT NULL
  • user_id (Field4) — NOT NULL
  • password (Field) — NOT NULL — NOT NULL
  • nickname (Field2) — NOT NULL