jugo-temp

Tables (5)

comment (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • board_type (Field) — ENUM('FREE', 'QNA', 'RESALE')
  • post_id (Field2)
  • root_id (Field5)
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

free_board (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • writer_id (Field)
  • title (Field2) — varchar(255)
  • content (Field3) — varchar(255)
  • created_at (Field4) — timestamp
  • updated_at (Field5) — timestamp

qna_board (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • writer_id
  • title — varchar(255)
  • content — varchar(255)
  • created_at — timestamp

resale_board (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • writer_id (Field)
  • price (Field3) — int
  • title (Field2) — varchar(255)
  • content (Field4) — varchar(255)
  • status (Field5) — ENUM('SALE', 'SOLDOUT')
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp

users (Untitled)

  • id — Primary key — NOT NULL
  • login_type — ENUM('KAKAO', 'GOOGLE', 'PASSWORD')
  • email — varchar(255)
  • password — varchar(255)
  • name — varchar(16)
  • nickname — varchar(16)