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