Seoul42
Tables (17)
ApiKey (CopyOfPiscineIndex)
- id — Auto — Primary key — NOT NULL
- name — Char(20)
- uid — Char(100) — NOT NULL
- secret — Char(100) — NOT NULL
Board
- id — Auto — Primary key — NOT NULL
- name (게시판 이름) — char(255) — NOT NULL
- is_anonymous (익명여부) — Boolean — NOT NULL
- user (만든이) — ForeignKey — Foreign key → MyUser.login — NOT NULL — settings.AUTH_USER_MODEL,
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
BoardComment
- id — Auto — Primary key — NOT NULL
- user (작성자) — ForeignKey — Foreign key → MyUser.login — settings.AUTH_USER_MODEL.
- post — ForeignKey — Foreign key → BoardPost.id — NOT NULL — related_name="comments",
- content (내용) — Text — NOT NULL
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
BoardPost
- id — Auto — Primary key — NOT NULL
- board — ForeignKey — Foreign key → Board.id — NOT NULL — related_name="posts",
- user (작성자) — ForeignKey — Foreign key → MyUser.login — settings.AUTH_USER_MODEL.
- title (제목) — Char(255) — NOT NULL
- content (내용) — Text
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
Club
- id — Auto — Primary key — NOT NULL
- master — ForeignKey — Foreign key → MyUser.login — NOT NULL — settings.AUTH_USER_MODEL
- name (소모임 이름) — Char(100) — NOT NULL
- content (소모임 소개) — Text — NOT NULL
- can_join (가입가능여부) — Boolean — NOT NULL
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
ClubBoard
- id — Auto — Primary key — NOT NULL
- name (게시판 이름) — char(255) — NOT NULL
- user (만든이) — ForeignKey — Foreign key → MyUser.login — NOT NULL — settings.AUTH_USER_MODEL,
- club — ForeignKey — Foreign key → Club.id — NOT NULL
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
ClubBoardComment
- id — Auto — Primary key — NOT NULL
- post — ForeignKey — Foreign key → ClubBoardPost.id — NOT NULL
- user (작성자) — ForeignKey — Foreign key → MyUser.login — settings.AUTH_USER_MODEL.
- content (내용) — Text — NOT NULL
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
ClubBoardPost
- id — Auto — Primary key — NOT NULL
- board — ForeignKey — Foreign key → ClubBoard.id — NOT NULL
- user (작성자) — ForeignKey — Foreign key → MyUser.login — NOT NULL — settings.AUTH_USER_MODEL.
- title (제목) — Char(255) — NOT NULL
- content (내용) — Text
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
ClubMember
- id — Auto — Primary key — NOT NULL
- club — ForeignKey — Foreign key → Club.id — NOT NULL — Club, related_name="members",
- user — ForeignKey — Foreign key → MyUser.login — NOT NULL — settings.AUTH_USER_MODEL,
- introducing (자기소개) — Text — NOT NULL
- is_join (가입여부) — Boolean — NOT NULL
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
Coalition (Coaliton)
- id — Integer — Primary key — NOT NULL
- name (길드 이름) — Char(50) — NOT NULL
- color (길드 색상) — Char(7) — NOT NULL
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
Food
- id — Auto — Primary key — NOT NULL
- name (가게 이름) — char(255) — NOT NULL
- user (등록자) — ForeignKey — Foreign key → MyUser.login — NOT NULL — settings.AUTH_USER_MODEL,
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
FoodReview
- id — Auto — Primary key — NOT NULL
- user (작성자) — ForeignKey — Foreign key → MyUser.login — settings.AUTH_USER_MODEL.
- is_anonymous (익명여부) — Boolean — NOT NULL
- content (내용) — Text — NOT NULL
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
- food — ForeignKey — Foreign key → Food.id — NOT NULL
FtUser
- id (42 id) — Integer — Primary key — NOT NULL
- login (로그인 아이디) — Char(20) — NOT NULL
- data (유저 데이터) — JSON — NOT NULL
- coalition (길드) — ForeignKey — Foreign key → Coalition.id
- coalition_data (길드 데이터) — JSON
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
MyUser
- login — Char(20) — Primary key — NOT NULL
- id (42 id) — Integer — NOT NULL
- email — Email — NOT NULL
- is_active — Boolean — NOT NULL
- allow_piscine_list — Boolean — NOT NULL
- user_type — Integer — NOT NULL
- is_admin — Boolean — NOT NULL
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
PiscineIndex
- id — Auto — Primary key — NOT NULL
- pool_month — Char(15) — NOT NULL
- pool_year — Char(6) — NOT NULL
- name (피신기수) — Char(15) — NOT NULL
Tier (TierLog)
- id — Auto — Primary key — NOT NULL
- ft_user — ForeignKey — Foreign key → FtUser.id — NOT NULL
- coalition_point (길드 포인트) — Integer — NOT NULL
- tier_name (티어 이름) — Char(13) — NOT NULL
- tier_rank (순위) — Integer — NOT NULL
- created_at (생성일) — DateTime — NOT NULL
- updated_at (수정일) — DateTime — NOT NULL
TierLog (TierIndex)
- tier — ForeignKey — Foreign key → Tier.id — NOT NULL