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