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