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)