물리
테이블 (9)
Copy Of Untitled2 (BOARD_COMMENT)
- Key (BOARD_COMMENT_NO) — NUMBER — 기본 키 — NOT NULL
- Field (LEVEL) — NUMBER — NOT NULL
- Field (CONTENT) — VARCHAR2(2000)
- Field (COMMENT_REF) — NUMBER
- Field (DATE) — DATE
- Field (CATEGORY) — CHAR(1) — NOT NULL
- Field (DEL_FLAG) — CHAR(1)
- ID (WRITER) — VARCHAR2(20) — 외래 키 → MEMBER.ID — NOT NULL
- Key (BOARD_REF) — NUMBER — 외래 키 → Untitled.Key — NOT NULL
MEMBER (Member)
- ID (MEMBER_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
- PASSWORD — VARCHAR2(20) — NOT NULL
- NAME — VARCHAR2(100) — NOT NULL
- PROFILE_IMAGE — VARCHAR2(200)
- Field (PASSPORT) — VARCHAR2(10) — NOT NULL
- PHONE — CHAR(11) — NOT NULL
- GENDER — CHAR(1) — NOT NULL
- AGE — NUMBER — NOT NULL
- BIRTH — DATE — NOT NULL
- ADDRESS — VARCHAR2(200) — NOT NULL
- EMAIL — VARCHAR2(200) — NOT NULL
- ENROLL_DATE — DATE — NOT NULL
- Field (DEL_FLAG) — CHAR(1)
- HOSTYN (ROLE) — CHAR(1) — NOT NULL
REGISTRATION (Registration)
- ID (REG_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
- GUEST COUNT (GUEST_COUNT) — NUMBER — NOT NULL
- DATE — DATE — NOT NULL
- CHKIN DATE (CHKIN_DATE) — DATE — NOT NULL
- CHKOUT_DATE — DATE — NOT NULL
- PAY YN (PAY_YN) — CHAR(1) — NOT NULL
- Field (DEL_FLAG) — CHAR(1)
- ID (REG_MEMBER_ID) — VARCHAR2(20) — 외래 키 → MEMBER.ID — NOT NULL
- Key (PLAY_ID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (PLACE_ID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (PLAY)
- Key (PLAY_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
- Field (COMPANY) — VARCHAR2(50) — NOT NULL
- Field (THUMBNAIL) — VARCHAR2(200)
- Field (NAME) — VARCHAR2(100) — NOT NULL
- Field (SCORE) — NUMBER
- Field (LOC) — VARCHAR2(50) — NOT NULL
- Field (ADDRESS) — VARCHAR2(200) — NOT NULL
- Field (PRICE) — NUMBER — NOT NULL
- Field (TIME) — NUMBER — NOT NULL
- Field (AVAIL_COUNT) — NUMBER — NOT NULL
- Field (LANGUAGE) — VARCHAR2(30) — NOT NULL
- Field (NOTE) — VARCHAR2(1000) — NOT NULL
- Field (FOOD) — VARCHAR2(200)
- Field (EQUIPMENT) — VARCHAR2(200)
- Field (TRANSPORT) — VARCHAR2(200)
- Field (DEL_FLAG) — CHAR(1)
Untitled (BOARD)
- Key (BOARD_NO) — NUMBER — 기본 키 — NOT NULL
- Field (TITLE) — VARCHAR2(200) — NOT NULL
- Field (WRITER) — VARCHAR2(20)
- Field (CONTENT) — VARCHAR2(10000) — NOT NULL
- Field (DATE) — DATE
- Field (READ_COUNT) — NUMBER
- Field (ORIGINAL_FILENAME) — VARCHAR2(200)
- Field2 (RENAMED_FILENAME) — VARCHAR2(200)
- Field (CATEGORY) — CHAR(1) — NOT NULL
- Field (DEL_FLAG) — CHAR(1)
- ID (MEMBER_ID) — VARCHAR2(20) — 외래 키 → MEMBER.ID — NOT NULL
Untitled (PLACE)
- Key (PLACE_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
- Field (THUMBNAIL) — VARCHAR2(200)
- Field (NAME) — VARCHAR2(100) — NOT NULL
- Field (SCORE) — NUMBER — NOT NULL
- Field (LOC) — VARCHAR2(50) — NOT NULL
- Field (ADDRESS) — VARCHAR2(200) — NOT NULL
- Field (PRICE) — NUMBER — NOT NULL
- Field (CHKIN_TIME) — Timestamp
- Field (CHKOUT_TIME) — Timestamp
- Field (AVAIL_COUNT) — NUMBER — NOT NULL
- Field (NOTE) — VARCHAR2(1000) — NOT NULL
- Field (ROOM_COUNT) — NUMBER
- Field2 (FACILITY) — VARCHAR2(150)
- Field (DEL_FLAG) — CHAR(1)
- ID (HOST_MEMBER_ID) — VARCHAR2(20) — 외래 키 → MEMBER.ID — NOT NULL
Untitled (COMMENT)
- Key (COMMENT_ID) — NUMBER — 기본 키 — NOT NULL
- Field (LEVEL) — NUMBER — NOT NULL
- Field2 (CONTENT) — VARCHAR2(2000) — NOT NULL
- Field (SCORE) — NUMBER — NOT NULL
- Field (REF) — NUMBER — NOT NULL
- Field (COMMENT_REF) — NUMBER
- Field (DATE) — DATE
- Field (CATEGORY) — CHAR(1) — NOT NULL
- Field (DEL_FLAG) — CHAR(1)
- Key (PLAY_ID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (PLACE_ID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (IMAGESTORE)
- Field (CATEGORY) — CHAR(1) — NOT NULL
- Field (ORIGINAL_FILENAME) — VARCHAR2(200) — NOT NULL
- Field (RENAMED_FILENAME) — VARCHAR2(200) — NOT NULL
- Field (IMAGE_NO) — Number — NOT NULL
- Key (PLAY_ID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (PLACE_ID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (AVAILDATE)
- Field (AVAIL_DATE) — DATE
- Field2 (CATEGORY) — CHAR(1)
- Key (PLAY_ID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (PLACE_ID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL