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