Backend

Tables (8)

board_alarm (Untitled7)

  • alarm_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • qboard_id (Key3) — Foreign key → quick_board.qboard_id — NOT NULL
  • qanswer_id (Key4) — Foreign key → quick_board_answer.qanswer_id — NOT NULL
  • is_read (Field)

quick_board (Untitled2)

  • qboard_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • qboard_content (Field)
  • qboard_date (Field2)

quick_board_answer (Untitled3)

  • qanswer_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • qboard_id (Key3) — Foreign key → quick_board.qboard_id — NOT NULL
  • qanswer_date (Field)
  • qanswer_content (Field2)

quick_board_answer_like (Untitled4)

  • qboard_id (Key) — Foreign key → quick_board.qboard_id — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL

quick_board_hashtag (Untitled5)

  • qboard_hashtag (Key2) — Primary key — NOT NULL
  • qboard_id (Key) — Foreign key → quick_board.qboard_id — NOT NULL

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • user_nickname (Field)
  • user_pw (Field2)
  • user_birth (Field3)
  • is_manager (Field4)

user_hashtag (Untitled6)

  • user_hashtag (Key2) — Primary key — NOT NULL
  • user_id (Key) — Foreign key → user.user_id — NOT NULL

user_hashtag_filter (Untitled8)

  • user_hashtag (Key2) — Foreign key → user_hashtag.user_hashtag — NOT NULL
  • user_id (Key) — Foreign key → user_hashtag.user_id — NOT NULL
  • filter_mode (Field)