semi

Tables (11)

dog_friend_board

  • num — INT — Primary key — NOT NULL
  • id — VARCHAR(30)
  • subject — VARCHAR(100)
  • content — VARCHAR(2000)
  • writeday — DATETIME
  • read_count — INT

dog_profile

  • idx — INT — Primary key — NOT NULL
  • member_num — INT — Foreign key → member.num
  • name — VARCHAR(30)
  • gender — VARCHAR(30)
  • dog_size — VARCHAR(10)
  • birthday — VARCHAR(20)
  • photo — VARCHAR(100)
  • main_dog — INT
  • INDEX — `member_num`

dog_talking_answer

  • idx — INT — Primary key — NOT NULL
  • Key — Primary key — NOT NULL
  • board_num — INT — Foreign key → dog_talking_board.num
  • id — VARCHAR(30)
  • content — VARCHAR(1000)
  • writeday — DATETIME
  • INDEX — `board_num`

dog_talking_board

  • num — INT — Primary key — NOT NULL
  • id — VARCHAR(30)
  • photo — VARCHAR(100)
  • content — VARCHAR(3000)
  • writeday — DATETIME
  • readcount — INT
  • likes — INT

member

  • num — INT — Primary key — NOT NULL
  • nickname — VARCHAR(20)
  • id — VARCHAR(20)
  • password — VARCHAR(20)
  • hp — VARCHAR(20)
  • addr — VARCHAR(200)
  • email — VARCHAR(100)
  • create_day — DATETIME
  • auth — INT

message

  • num — INT — Primary key — NOT NULL
  • sender — VARCHAR(50)
  • receiver — VARCHAR(50)
  • content — VARCHAR(1000)
  • writeday — DATETIME
  • is_read — INT

notification_board

  • num — INT — Primary key — NOT NULL
  • title — VARCHAR(50)
  • content — VARCHAR(2000)
  • writeday — DATETIME

place_share_answer

  • idx — INT — Primary key — NOT NULL
  • board_num — INT — Foreign key → place_share_board.num
  • id — VARCHAR(30)
  • content — VARCHAR(1000)
  • writeday — DATETIME
  • INDEX — `board_num`

place_share_board

  • num — INT — Primary key — NOT NULL
  • id — VARCHAR(30)
  • subject — VARCHAR(50)
  • content — VARCHAR(2000)
  • photo_name — VARCHAR(100)
  • writeday — DATETIME
  • read_count — INT
  • likes — INT
  • place_la — VARCHAR(200)
  • place_ma — VARCHAR(200)
  • map_addr — VARCHAR(200)

qna_answer

  • idx — INT — Primary key — NOT NULL
  • board_num — INT — Foreign key → qna_board.num
  • admin_id — VARCHAR(100)
  • content — VARCHAR(2000)
  • writeday — DATETIME
  • INDEX — `board_num`

qna_board

  • num — INT — Primary key — NOT NULL
  • id — VARCHAR(100)
  • title — VARCHAR(500)
  • content — VARCHAR(2000)
  • writeday — DATETIME
  • readcount — INT
  • secret — INT