도토리

테이블 (7)

adminLoginTb (관리자 로그인 테이블)

  • loginSeq (PK) — INT — 기본 키 — NOT NULL
  • loginId (UK) — VARCHAR
  • loginPw (Field1) — VARCHAR
  • creareDt (Field2) — DATETIME
  • updateDt (Field3) — DATETIME
  • delDt (Field4) — DATETIME
  • delYn (Field5) — TINYINT(1)

categoryTb (채널 카테고리 구분 테이블)

  • categorySeq (PK) — INT — 기본 키 — NOT NULL
  • categoryName_en (Field5) — VARCHAR
  • channelName_ko (Field) — VARCHAR
  • creareDt (Field2) — DATETIME
  • updateDt (Field3) — DATETIME
  • delDt (Field4) — DATETIME
  • delYn (Field6) — TINYINT(1)

channelTb (채널 테이블)

  • channelSeq (PK) — INT — 기본 키 — NOT NULL
  • categorySeq (FK1) — INT — 외래 키 → categoryTb.categorySeq — NOT NULL
  • loginSeq (FK2) — INT — 외래 키 → adminLoginTb.loginSeq — NOT NULL
  • channelName_en (Field5) — VARCHAR
  • channelName_ko (Field) — VARCHAR
  • creareDt (Field2) — DATETIME
  • updateDt (Field3) — DATETIME
  • delDt (Field4) — DATETIME
  • delYn (Field6) — TINYINT(1)

pageTb (페이지)

  • pageSeq (PK) — INT — 기본 키 — NOT NULL
  • channelSeq (PK2) — INT — 외래 키 → channelTb.channelSeq — NOT NULL
  • categorySeq (FK1) — INT — 외래 키 → channelTb.categorySeq — NOT NULL
  • loginSeq (FK2) — INT — 외래 키 → channelTb.loginSeq — NOT NULL
  • pageType (Field) — INT
  • pageTypeName_en (Field2) — VARCHAR
  • pageTypeName_ko (Field4) — VARCHAR
  • pageTitle (Field3) — VARCHAR
  • createDt (Field5) — DATETIME
  • updateDt (Field6) — DATETIME
  • delDt (Field7) — DATETIME
  • delYn (Field8) — TINYINT(1)

profileTb (프로필 테이블)

  • profileSeq (PK) — INT — 기본 키 — NOT NULL
  • loginSeq (FK) — INT — 외래 키 → userLoginTb.loginSeq — NOT NULL
  • name (Field) — VARCHAR
  • birthDay (Field2) — DATE
  • phone (Field3) — VARCHAR
  • createDt (Field4) — DATETIME
  • updateDt (Field5) — DATETIME
  • delDt (Field6) — DATETIME
  • delYn (Field7) — TINYINT(1)

subscribeTb (구독중인 테이블)

  • subscribeSeq (PK) — INT — 기본 키 — NOT NULL
  • loginSeq (PK2) — INT — 외래 키 → userLoginTb.loginSeq — NOT NULL
  • channelSeq (PK3) — INT — 외래 키 → channelTb.channelSeq — NOT NULL
  • categorySeq (FK1) — INT — 외래 키 → channelTb.categorySeq — NOT NULL
  • loginSeq (FK2) — INT — 외래 키 → channelTb.loginSeq — NOT NULL
  • createDt (Field) — DATETIME
  • updateDt (Field2) — DATETIME
  • delDt (Field3) — DATETIME
  • delYn (Field4) — TINYINT(1)

userLoginTb (유저 로그인 테이블)

  • loginSeq (PK) — INT — 기본 키 — NOT NULL
  • loginId (Field6) — VARCHAR
  • loginPw (Field1) — VARCHAR
  • creareDt (Field2) — DATETIME
  • updateDt (Field3) — DATETIME
  • delDt (Field4) — DATETIME
  • delYn (Field5) — TINYINT(1)