AWESOME_MENTOR

Tables (9)

ActivityBaordReview

  • id — INT — Primary key — NOT NULL
  • board — INT — Foreign key → ActivityBoard.id — NOT NULL
  • user — INT — Foreign key → User.id — NOT NULL
  • star — INT — NOT NULL — 별점
  • comment — TEXT — NOT NULL
  • registered_date — DATETIME — NOT NULL

ActivityBoard

  • id — INT — Primary key — NOT NULL
  • user — INT — Foreign key → User.id — NOT NULL
  • title — VARCHAR(128) — NOT NULL
  • content — TEXT — NOT NULL
  • organization — VARCHAR(128) — NOT NULL
  • registered_date — DATETIME — NOT NULL
  • last_update_date (ast_update_date) — DATETIME — NOT NULL
  • view_count — INT — NOT NULL
  • entry fee — VARCHAR(128) — NOT NULL
  • language — VARCHAR(128) — NOT NULL
  • place — VARCHAR(128) — NOT NULL
  • target_age_start — INT — NOT NULL
  • target_age_end — INT — NOT NULL
  • registration _start_date (registration_start_date) — DATE — NOT NULL
  • provider_url — VARCHAR(200)

ActivityBoardImage

  • id — INT — Primary key — NOT NULL
  • board — INT — Foreign key → ActivityBoard.id — NOT NULL
  • image — VARCHAR — NOT NULL

ActivityBoardKeyword

  • id — INT — Primary key — NOT NULL
  • board — INT — Foreign key → ActivityBoard.id — NOT NULL
  • keyword — INT — Foreign key → Keyword.id — NOT NULL

Keyword

  • id — INT — Primary key — NOT NULL
  • name1 — VARCHAR(128) — NOT NULL
  • name2 — VARCHJAR(128)
  • parents — INT — NOT NULL

User (CustomUser)

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(128) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • is_staff — BOOLEAN — NOT NULL
  • is_superuser — BOOLEAN — NOT NULL
  • last_login — BOOLEAN
  • dated_joined — BOOLEAN — NOT NULL
  • nickname — VARCHAR(128) — NOT NULL
  • password — VARCHAR(128) — NOT NULL
  • price — VARCHAR(20) — NOT NULL

UserCompletedActivities

  • id — INT — Primary key — NOT NULL
  • user — INT — Foreign key → User.id — NOT NULL
  • board — INT — Foreign key → ActivityBoard.id — NOT NULL

UserFavoriteActivities

  • id — INT — Primary key — NOT NULL
  • user — INT — Foreign key → User.id — NOT NULL
  • board — INT — Foreign key → ActivityBoard.id — NOT NULL

UserInterestedKeywords

  • id — INT — Primary key — NOT NULL
  • user — INT — Foreign key → User.id — NOT NULL
  • keword — INT — Foreign key → Keyword.id — NOT NULL