drafft
드래프트
테이블 (7)
codeDetail (코드디테일)
- codeDetailNo — int — 기본 키 — NOT NULL
- codeNo — int — 외래 키 → codeMst.codeNo — NOT NULL
- cdDetailNm — varchar
codeMst (코드)
- codeNo — int — 기본 키 — NOT NULL
- codeNm — varchar
entry (Untitled3)
- entryNo (Key) — int — 기본 키 — NOT NULL
- gatheringNo — int — 외래 키 → gathering.gatheringNo — NOT NULL
- userNo — int — 외래 키 → gathering.userNo — NOT NULL
- createDt (Field2) — timestamp
gathering (모임)
- gatheringNo — int — 기본 키 — NOT NULL
- userNo — int — 외래 키 → user.userNo — NOT NULL
- joinYn (Field3) — varchar
- part (종목) — int
- location (Field) — int
- time (Field2) — varchar
- memo (메모) — varchar
- createDt (생성일) — timestamp
- updateDt (수정일) — timestamp
location (Untitled)
- locationNo (Key) — int — 기본 키 — NOT NULL
- name (Field) — varchar
- addr (Field2) — varchar
- createDt (Field3) — timestamp
- updateDt (Field4) — timestamp
participant (Untitled2)
- participantNo (Key) — int — 기본 키 — NOT NULL
- locationNo (Key2) — int — 외래 키 → location.locationNo — NOT NULL
- joinYn (Field4) — varchar
- time (Field) — varchar
- userNo (Field2) — int
- createDt (Field3) — timestamp
user (회원)
- userNo — int — 기본 키 — NOT NULL
- userId — varchar
- pw (password) — varchar
- address (adresss) — varchar
- createDt (생성일) — timestamp
- updatedt (수정일) — timestamp