fleamarket

Tables (10)

Category (Untitled9)

  • category_id (Key) — bigint(20) — Primary key — NOT NULL
  • name (Field) — varchar(10)

Chat (Untitled5)

  • chat_id (Key) — bigint(20) — Primary key — NOT NULL
  • flea_id (Key3) — bigint(20) — Foreign key → Flea.flea_id — NOT NULL
  • user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
  • create_date (Field) — date

Chat_Comment (Untitled6)

  • chat_comment_id (Key) — bigtint(20) — Primary key — NOT NULL
  • chat_id (Key2) — bigint(20) — Foreign key → Chat.chat_id — NOT NULL
  • user_id (Key3) — bigint(20) — Foreign key → User.user_id — NOT NULL
  • create_date (Field2) — date
  • content (Field) — text
  • isview (Field3) — boolean

Flea (Untitled2)

  • flea_id (Key) — bigint(20) — Primary key — NOT NULL
  • user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
  • title (Field) — varchar(25)
  • content (Field2) — text
  • price (Field3) — integer
  • views (Field4) — integer
  • create_date (Field5) — date

Flea_Category (Untitled10)

  • flea_category_id (Key) — bigint(20) — Primary key — NOT NULL
  • flea_id (Key2) — bigint(20) — Foreign key → Flea.flea_id — NOT NULL
  • category_id (Key3) — bigint(20) — Foreign key → Category.category_id — NOT NULL

Flea_Img (Untitled8)

  • flea_img_id (Key) — bigint(20) — Primary key — NOT NULL
  • flea_id (Key2) — bigint(20) — Foreign key → Flea.flea_id — NOT NULL
  • path (Field) — varchar(256)

Flea_Like (Untitled3)

  • flea_like_id (Key) — bigint(20) — Primary key — NOT NULL
  • user_id (Key2) — bigint(20) — Foreign key → User.user_id — NOT NULL
  • flea_id (Key3) — bigint(20) — Foreign key → Flea.flea_id — NOT NULL
  • create_date (Field) — date

Place (Untitled7)

  • place_id (Key) — bigint(20) — Primary key — NOT NULL
  • sido (Field) — varchar(4)
  • gugun (Field2) — varchar(17)
  • dong (Field3) — varchar(26)

User (Untitled)

  • user_id (Key) — bigint(20) — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • password (Field2) — varchar(256)
  • create_date (Field3) — date

User_Place (Untitled4)

  • user_place_id (Key) — bigint(20) — Primary key — NOT NULL
  • create_date (Field) — date
  • place_id (Key2) — bigint(20) — Foreign key → Place.place_id — NOT NULL
  • user_id (Key3) — bigint(20) — Foreign key → User.user_id — NOT NULL