DEVIL
Tables (22)
arc_pht
- pno — INTEGER — Primary key — NOT NULL
- arno — INTEGER — NOT NULL
- adr — VARCHAR(255) — NOT NULL
arc_tag
- arno — INTEGER — Primary key — NOT NULL
- tno — INTEGER — Foreign key → tag.tno — NOT NULL
badge
- bno — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- photo — VARCHAR(255) — NOT NULL
- tno — INTEGER — Foreign key → tag.tno
- state — INTEGER — NOT NULL
- content — MEDIUMTEXT
bdg_eva
- beno — INTEGER — Primary key — NOT NULL
- bename — VARCHAR(50) — NOT NULL
bdg_stan
- bsno — INTEGER — Primary key — NOT NULL
- bno — INTEGER — Foreign key → badge.bno — NOT NULL
- beno — INTEGER — Foreign key → bdg_eva.beno — NOT NULL
- count — INTEGER
block
- blno — INTEGER — Primary key — NOT NULL
- uno — INTEGER — Foreign key → user.사용자번호 — NOT NULL
- cdt — DATE — NOT NULL
- dates — INTEGER — NOT NULL
- bl_rsn — MEDIUMTEXT — NOT NULL
- unbl_rsn — MEDIUMTEXT
category
- cano — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
comment
- cno — INTEGER — Primary key — NOT NULL
- arno — INTEGER — NOT NULL
- uno — INTEGER — Foreign key → user.사용자번호 — NOT NULL
- content — MEDIUMTEXT — NOT NULL
- cdt — DATETIME — NOT NULL
- ord — INTEGER
- step — INTEGER
- udt — DATETIME
- state — INTEGER — NOT NULL
- ddt — DATETIME
- selected — INTEGER — NOT NULL
- momno — INTEGER
follow
- fwer_no — INTEGER — Foreign key → user.사용자번호 — NOT NULL
- fwing_no — INTEGER — Foreign key → user.사용자번호 — NOT NULL
- cdt — DATETIME — NOT NULL
noti
- nno — INTEGER — Primary key — NOT NULL
- uno — INTEGER — Foreign key → user.사용자번호 — NOT NULL
- cdt — DATETIME — NOT NULL
- type — INTEGER — NOT NULL
- rdt — DATETIME
- cno — INTEGER — Foreign key → comment.cno
- fwer_no — INTEGER — Foreign key → user.사용자번호
- bno — INTEGER — Foreign key → badge.bno
region
- rgno — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
relo
- relo — INTEGER — Primary key — NOT NULL
- rgno — INTEGER — Foreign key → region.rgno — NOT NULL
- name — VARCHAR(50) — NOT NULL
repo_arc
- rpno — INTEGER — Foreign key → report.rpno — NOT NULL
- arno — INTEGER — NOT NULL
repo_comt
- rpno — INTEGER — Foreign key → report.rpno — NOT NULL
- cno — INTEGER — Foreign key → comment.cno — NOT NULL
repo_type
- rptno — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
repo_user
- rpno — INTEGER — Foreign key → report.rpno — NOT NULL
- uno — INTEGER — Foreign key → user.사용자번호 — NOT NULL
report
- rpno — INTEGER — Primary key — NOT NULL
- rptno — INTEGER — Foreign key → repo_type.rptno — NOT NULL
- uno — INTEGER — Foreign key → user.사용자번호 — NOT NULL
- cdt — DATETIME — NOT NULL
- status — INTEGER — NOT NULL
- pdt — DATETIME
tag
- tno — INTEGER — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- photo — VARCHAR(255)
- tag_color — VARCHAR(50) — NOT NULL
- font_color — VARCHAR(50) — NOT NULL
- state — INTEGER — NOT NULL
user
- 사용자번호 (uno) — INTEGER — NOT NULL — 사용자번호
- 이메일 (email) — VARCHAR(40) — NOT NULL — 이메일
- 닉네임 (nick) — VARCHAR(50) — 닉네임
- 전화번호 (tel) — VARCHAR(30) — 전화번호
- 이름 (name) — VARCHAR(50) — NOT NULL — 이름
- 암호 (pwd) — VARCHAR(255) — 암호
- 가입일 (cdt) — DATE — NOT NULL — 가입일
- 최근방문일 (rnt_vsdt) — DATETIME — 최종방문일
- 로그인유형 (log_type) — INTEGER — NOT NULL — 로그인유형
- 사진 (photo) — VARCHAR(255) — 사진
- 개인홈피주소 (hp_url) — VARCHAR(255) — 개인홈피주소
- 깃허브주소 (gh_url) — VARCHAR(255) — 깃허브주소
- 인스타주소 (in_url) — VARCHAR(255) — 인스타주소
- 트위터주소 (tw_url) — VARCHAR(255) — 트위터주소
- 차단여부 (blocked) — INTEGER — NOT NULL — 차단여부
- 기술스택 (tech) — MEDIUMTEXT — 기술스택
- 관리자여부 (auth) — INTEGER — NOT NULL — 관리자여부
- 알람알림여부 (noti) — INTEGER — NOT NULL — 알람알림여부
- 자기소개 (bio) — MEDIUMTEXT — 자기소개
- 활성상태 (state) — INTEGER — NOT NULL — 활성상태' ) COMMENT '유저'; ALTER TABLE user ADD CONSTRAINT PK_user PRIMARY KEY ( un
usr_bdg
- uno — INTEGER — Foreign key → user.사용자번호 — NOT NULL
- bno — INTEGER — Foreign key → badge.bno — NOT NULL
- adt — DATE — NOT NULL
- ord — INTEGER — NOT NULL
usr_bmk_arc
- arno — INTEGER — Primary key — NOT NULL
- uno — INTEGER — Foreign key → user.사용자번호 — NOT NULL
- cdt — DATETIME — NOT NULL
usr_tag
- uno — INTEGER — Foreign key → user.사용자번호 — NOT NULL
- tno — INTEGER — Foreign key → tag.tno — NOT NULL
- cdt — DATE — NOT NULL