`
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