erd
Tables (9)
AVAILDATE
- AVAIL_DATE — DATE
- CATEGORY — CHAR(1) — NOT NULL
- PLAY_ID — VARCHAR2(20)
- PLACE_ID — VARCHAR2(20)
BOARD
- BOARD_NO — NUMBER
- BOARD_TITLE — VARCHAR2(200) — NOT NULL
- BOARD_WRITER — VARCHAR2(20)
- BOARD_CONTENT — VARCHAR2(10000) — NOT NULL
- BOARD_ENROLL_DATE — DATE
- BOARD_READ_COUNT — NUMBER
- BOARD_ORIGINAL_FILENAME — VARCHAR2(200)
- BOARD_RENAMED_FILENAME — VARCHAR2(200)
- BOARD_CATEGORY — CHAR(1) — NOT NULL
- BOARD_DEL_FLAG — CHAR(1)
BOARD_undefined
- 2000) — NOT — NOT NULL
- BOARD_undefined_REF — NUMBER — NOT NULL
COMMENT
- COMMENT — (_ID NUMBER NOT NULL undefined_LEVEL NUMBER DEFAULT 1 NOT NULL undefined_CONTENT VARCHAR2(2000) — NOT NULL — _ID NUMBER NOT NULL undefined_LEVEL NUMBER DEFAULT 1 NOT NULL undefined_CONTENT VARCHAR2(2000) NOT NULL PRODUCT_SCORE N…
- PRODUCT_REF — NUMBER — NOT NULL
- undefined_REF — NUMBER — NOT NULL
- PLACE_ID — VARCHAR2(20)
IMAGESTORE
- PRODUCT_CATEGORY — CHAR(1) — NOT NULL
- ORIGINAL_FILENAME — VARCHAR2(200) — NOT NULL
- RENAMED_FILENAME — VARCHAR2(200) — NOT NULL
- IMAGE_NO — Number — NOT NULL
- PLAY_ID — VARCHAR2(20)
- PLACE_ID — VARCHAR2(20)
MEMBER
- MEMBER_ID — VARCHAR2(20)
- PASSWORD — VARCHAR2(300) — NOT NULL
- MEMBER_NAME — VARCHAR2(100) — NOT NULL
- PROFILE_ORIGINAL_FILE_NAME — VARCHAR2(200)
- PROFILE_RENAMED_FILE_NAME — VARCHAR2(200)
- MEMBER_PASSPORT — VARCHAR2(15) — NOT NULL
- PHONE — CHAR(11) — NOT NULL
- GENDER — CHAR(1) — NOT NULL
- AGE — NUMBER — NOT NULL
- BIRTH — DATE — NOT NULL
- MEMBER_ADDRESS — VARCHAR2(200) — NOT NULL
- MEMBER_EMAIL — VARCHAR2(200) — NOT NULL
- MEMBER_ENROLL_DATE — DATE
- MEMBER_DEL_FLAG — CHAR(1)
- MEMBER_ROLE — CHAR(1)
PLACE
- PLACE_ID — VARCHAR2(20)
- PLACE_THUMBNAIL_ORIGINAL_FILENAME — VARCHAR2(200) — NOT NULL
- PLACE_THUMBNAIL_RENAMED_FILENAME — VARCHAR2(200) — NOT NULL
- PLACE_NAME — VARCHAR2(100) — NOT NULL
- PLACE_SCORE — NUMBER — NOT NULL
- PLACE_LOC — VARCHAR2(50) — NOT NULL
- PLACE_ADDR — VARCHAR2(200) — NOT NULL
- PLACE_PRICE — NUMBER — NOT NULL
- PLACE_CHKIN_TIME — TIMESTAMP — NOT NULL
- PLCAE_CHKOUT_TIME — TIMESTAMP — NOT NULL
- PLACE_AVAIL_COUNT — NUMBER — NOT NULL
- PLACE_NOTE — VARCHAR2(1000) — NOT NULL
- PLACE_ROOM_COUNT — NUMBER — NOT NULL
- PLACE_FACILITY — VARCHAR2(150) — NOT NULL
- PLACE_DEL_FLAG — CHAR(1)
- HOST_MEMBER_ID — VARCHAR2(20)
PLAY
- PLAY_ID — VARCHAR2(20)
- COMPANY — VARCHAR2(50) — NOT NULL
- PLAY_THUMBNAIL_ORIGINAL_FILENAME — VARCHAR2(200)
- PLAY_THUMBNAIL_RENAMED_FILENAME — VARCHAR2(200)
- PLAY_NAME — VARCHAR2(100) — NOT NULL
- PLAY_SCORE — NUMBER — NOT NULL
- PLAY_LOC — VARCHAR2(50) — NOT NULL
- PLAY_ADDR — VARCHAR2(200) — NOT NULL
- PLAY_PRICE — NUMBER — NOT NULL
- PLAY_TIME — NUMBER — NOT NULL
- PLAY_AVAIL_COUNT — NUMBER — NOT NULL
- PLAY_LANGUAGE — VARCHAR2(30) — NOT NULL
- PLAY_NOTE — VARCHAR2(1000) — NOT NULL
- PLAY_FOOD — VARCHAR2(200)
- PLAY_EQUIPMENT — VARCHAR2(200)
- PLAY_TRANSPORT — VARCHAR2(200)
- PLAY_DEL_FLAG — CHAR(1)
REGISTRATION
- REG_ID — VARCHAR2(20) — Primary key — NOT NULL
- GUEST_COUNT — NUMBER — NOT NULL
- REG_DATE — DATE — NOT NULL
- REG_CHKIN_DATE — DATE — NOT NULL
- REG_CHKOUT_DATE — DATE — NOT NULL
- REG_PAY_YN — CHAR(1) — NOT NULL
- REG_DEL_FLAG — CHAR(1)
- REG_MEMBER_ID — VARCHAR2(20) — NOT NULL
- PLAY_ID — VARCHAR2(20)
- PLACE_ID — VARCHAR2(20)