`

Tables (6)

Board

  • id (Key) — bigint — Primary key — NOT NULL
  • category_id (FK2) — bigInt — Foreign key → Category.category_id — NOT NULL
  • customer_id (FK) — bigint — NOT NULL
  • title (Field2) — varchar(30)
  • content (Field3) — varchar(300)
  • thumbnail (Field9) — varchar(100)
  • comment (Field4) — varchar(100)
  • likes (Field5) — bigint
  • view_cnt (Field6) — bigint
  • create_at (Field7) — timestamp
  • update_at (Field8) — timestamp

Category (Untitled)

  • category_id (Key) — bigInt — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • create_dt (Field2) — timestamp
  • update_dt (Field3) — timestamp

Customer

  • customer_id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar(30)
  • password (Field2) — varchar(250)
  • username (Field3) — varchar(50)
  • nickname (Field4) — varchar(50)
  • create_dt (Field5) — timestamp
  • update_dt (Field6) — timestamp

boardImage (board_image)

  • id (Key) — bigInt — Primary key — NOT NULL
  • board_id (FK) — bigint — Foreign key → Board.id — NOT NULL
  • image_uri (Field) — varchar(250)
  • create_dt (Field2) — timestamp
  • update_dt (Field3) — timestamp

comment

  • comment_id (Key) — bigInt — Primary key — NOT NULL
  • board_id (Key2) — bigint — Foreign key → Board.id — NOT NULL
  • comment (Field) — varchar(100)
  • create_dt (Field2) — timestamp
  • update_dt (Field3) — timestamp
  • parent_comment_id (Field5) — bigint
  • customer_id (Field4) — bigint

likes

  • likes_id (Key) — bigInt — Primary key — NOT NULL
  • user_id (Field) — bigint
  • board_id (FK) — bigint — Foreign key → Board.id — NOT NULL
  • create_dt (Field3) — timestamp