ProgrammingTraining

Tables (4)

Rank (랭킹)

  • Rank_count (조회수 순위) — BIGINT — Primary key
  • Rank_likeconunt (좋아요 순위) — BIGINT — Primary key

User (유저)

  • id (닉네임) — VARHAR(15) — Primary key — NOT NULL
  • name (실명) — VARCHAR(8) — NOT NULL
  • password (비밀번호) — VARCHAR(15) — NOT NULL

make_Templeate (유형검사 만들기)

  • title (제목) — VARCHAR(15) — Primary key — NOT NULL
  • contant (내용) — MIDUMTEXT — NOT NULL
  • createdate (만든날짜) — DTAETIME
  • amend (수정날짜) — DATETIME
  • id (닉네임) — VARHAR(15) — Foreign key → User.id — NOT NULL

share_Templeate (공유한 유형검사)

  • Rank_count (조회수 순위) — BIGINT — Foreign key → Rank.Rank_count
  • Rank_likeconunt (좋아요 순위) — BIGINT — Foreign key → Rank.Rank_likeconunt
  • id (닉네임(작성자))) — VARHAR(15) — Foreign key → User.id — NOT NULL
  • count (조회수) — BIGINT
  • title (제목) — VARCHAR(15) — NOT NULL
  • contant (내용) — MIDUMTEXT — NOT NULL
  • createdate (게시한 날짜) — DTAETIME
  • Like_count (좋아요 수) — BIGINT