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)