도토리
테이블 (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)