bit

Tables (5)

feed_board (Untitled4)

  • feed_no (Key) — INT — Primary key — NOT NULL
  • feed_writer (Field7) — VARCHAR(20)
  • feed_photo (Field2) — VARCHAR(30)
  • feed_content (Field) — VARCHAR(2000)
  • feed_writeday (Field3) — DATETIME
  • feed_likes (Field5) — INT
  • feed_tag (Field6) — VARCHAR(1000)

feed_board_answer (Untitled5)

  • feed_no (Key) — INT — Foreign key → feed_board.feed_no — NOT NULL
  • fanswer_no (Field3) — INT
  • fanswer_writer (Field4) — VARCHAR(20)
  • fanswer_content (Field) — VARCHAR(1000)
  • fanswer_writeday (Field2) — DATETIME

tour_board (Untitled2)

  • board_no (Key2) — INT — Primary key — NOT NULL
  • tour_no (Key) — INT — Foreign key → tour_group.tour_no — NOT NULL
  • board_writer (Field10) — VARCHAR(20)
  • board_subject (Field6) — VARCHAR(100)
  • board_content (Field) — VARCHAR(2000)
  • board_writeday (Field3) — DATETIME
  • board_readcount (Field4) — INT
  • regroup (Field7) — INT
  • restep (Field8) — INT
  • relevel (Field9) — INT

tour_board_answer (Untitled3)

  • board_no (Key2) — INT — Foreign key → tour_board.board_no — NOT NULL
  • banswer_no (Field5) — INT
  • banswer_writer (Field4) — VARCHAR(20)
  • banswer_photo (Field2) — VARCHAR(30)
  • banswer_content (Field3) — VARCHAR(1000)
  • banswer_writeday (Field) — DATETIME

tour_group (Untitled)

  • tour_no (Key) — INT — Primary key — NOT NULL
  • tour_name (Field) — VARCHAR(100)
  • tour_start (Field2) — VARCHAR(20)
  • tour_end (Field3) — VARCHAR(20)
  • member_list (Field4) — VARCHAR(1000)
  • tour_location (Field5) — VARCHAR(50)