나혼자산다

테이블 (9)

Untitled (BOARD)

  • Key (BOARD_CODE) — PK — 기본 키 — NOT NULL
  • USER_CODE — FK — 외래 키 → 회원.USER_CODE — NOT NULL
  • Field2 (VERIFY) — NN
  • Field3 (TITLE) — NN
  • Field4 (CONTENT) — NN
  • Field5 (VIEW_COUNT) — DEFAULT(0)
  • Field6 (COMMENT_COUNT) — DEFAULT(0)
  • Field7 (REGDATE) — NN,DEFAULT(SYSDATE)
  • Field8 (UPDATE_DATE)

Untitled (NOTE)

  • Key (NOTE_CODE) — PK — 기본 키 — NOT NULL
  • USER_CODE — PK/FK — 외래 키 → 회원.USER_CODE — NOT NULL
  • USER_CODE (USER_CODE2) — PK/FK — 외래 키 → 회원.USER_CODE — NOT NULL
  • Field (DIVISION) — NN
  • Field2 (SEND_DATE) — NN
  • Field3 (RECEIVE_DATE) — NN

Untitled (NOTE_CONTENT)

  • Key (NOTE_CODE) — PK — 외래 키 → Untitled.Key — NOT NULL
  • USER_CODE — PK/FK — 외래 키 → Untitled.USER_CODE — NOT NULL
  • USER_CODE (USER_CODE2) — PK/FK — 외래 키 → Untitled.USER_CODE — NOT NULL
  • Field (NOTE_CONTENT) — NN

Untitled (FOOD)

  • Key (MARKER_CODE) — PK — 기본 키 — NOT NULL
  • USER_CODE — FK — 외래 키 → 회원.USER_CODE — NOT NULL
  • Field (FOOD_NAME) — NN
  • Field (CONTENT) — NN
  • Field (IMAGE)
  • Field (LOCATION) — NN

Untitled (CHAT_ROOM)

  • Key (CHATROOM_CODE) — PK — 기본 키 — NOT NULL
  • Field (CHAT_TITLE) — NN
  • Field2 (CHAT_PEOPLE) — NN
  • Field3 (CHAT_SEQNUM) — NN

Untitled (CHAT_MESSAGE)

  • Key (CHAT_CODE) — PK — 기본 키 — NOT NULL
  • USER_CODE — FK — 외래 키 → 회원.USER_CODE — NOT NULL
  • Key (CHATROOM_CODE) — FK — 외래 키 → Untitled.Key — NOT NULL
  • Field (CHAT_CONTENT) — NN
  • Field (SEND_TIME) — NN
  • Field (READER) — DEFAULT(0)

Untitled (FILE)

  • Key (FILE_CODE) — PK — 기본 키 — NOT NULL
  • Key (BOARD_CODE) — FK — 외래 키 → Untitled.Key — NOT NULL
  • USER_CODE — FK — 외래 키 → Untitled.USER_CODE — NOT NULL
  • Field (FILE_ORIGINAL_NAME) — NN
  • Field2 (FILE_SERVER_NAME) — NN
  • Field3 (FILE_SOURCE) — NN
  • Field4 (FILE_SIZE) — NN
  • Field5 (FILE_DATE) — DATE

Untitled (REPLY)

  • Key (REPLY_CODE) — PK — 기본 키 — NOT NULL
  • Key (BOARD_CODE) — PK — 외래 키 → Untitled.Key — NOT NULL
  • USER_CODE — FK — 외래 키 → Untitled.USER_CODE — NOT NULL
  • Field (CONTENT) — NN
  • Field2 (REG_DATE)
  • Field3 (UPDATE_DATE)
  • Field4 (REPLY_GROUP)
  • Field5 (REPLY_SEQ)
  • Field6 (REPLY_DEPTH)

회원 (USER)

  • USER_CODE — PK — 기본 키 — NOT NULL
  • VERIFY — NN
  • USERID — NN
  • USERNAME — NN
  • PASSWORD — NN
  • ADDRESS — NN
  • REGDATE — DEFAULT(SYSDATE), NN