물리

테이블 (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