2022GDG
Tables (4)
Board (게시판)
- board_id (Key) — Primary key — NOT NULL
- category_id (Key2) — Foreign key → Category.category_id — NOT NULL
- user_id (Key3) — Foreign key → Member.member_id — NOT NULL
- board_image_id (Key4) — Foreign key → Board_Image.board_image_id — NOT NULL
- board_title (Field)
- board_date (Field5)
- board_location (Field4) — varchar
- board_content (Field2)
- board_total_count (Field10) — int
- board_recent_count (Field11) — int
- created_time (Field6)
- update_time (Field7)
- created_by (Field8)
- modified_by (Field9)
Board_Image (게시판 이미지)
- board_image_id (Key) — Primary key — NOT NULL
- imageName (Field)
- umageUrl (Field2)
Category (여행 카테고리)
- category_id (Key) — Primary key — NOT NULL
- category_main (Field)
- category_sub (Field2)
Member (사용자)
- member_id (Key) — Primary key — NOT NULL
- member_login_id (Field)
- member_name (Field2)
- member_password (Field3)
- member_trip (Field4)
- created_time (Field5)
- update_time (Field6)
- created_by (Field7)
- modified_by (Field8)