나혼자산다
테이블 (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