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