BesideYou

Tables (4)

CONTACT (일 대 일 문의)

  • CONTACT_CODE — NUMBER — Primary key — NOT NULL
  • MEMBER_CODE — NUMBER — Foreign key → Member.MEMBER_CODE — NOT NULL
  • CONTACT_CATEGORY — NUMBER
  • CONTACT_SUBJECT — VARCHAR2
  • CONTACT_CONTENT (CONTACTC_CONTENT) — VARCHAR2
  • CONTACT_STATE — NUMBER(2)
  • CONTACT_DATE — DATE

CONTACT_REPLY (일 대 일 문의답변)

  • Key — Primary key — NOT NULL
  • Field

COUNSELOR (상담사)

  • COUNSELOR_CODE — NUMBER — Primary key — NOT NULL
  • MEMBER_CODE — NUMBER — Foreign key → Member.MEMBER_CODE — NOT NULL
  • LOCATION (COUNSELOR_LOCATION) — VARCHAR2
  • CAREER (COUNSELOR_CAREER) — VARCHAR2
  • RANK (COUNSELOR_RANK) — VARCAHR2
  • AREA (COUNSELOR_AREA) — VARCHAR2

Member (회원)

  • MEMBER_CODE — NUMBER — Primary key — NOT NULL
  • ID(UNIQUE) (MEMBER_ID) — VARCHAR2 — (UNIQUE)
  • PASSWORD (MEMBER_PASSWORD) — VARCHAR2
  • NAME (MEMBER_NAME) — VARCHAR2
  • ALIAS (MEMBER_ALIAS) — VARCHAR2
  • ADDR (MEMBER_ADDR) — VARCAHR2
  • PHONE (MEMBER_PHONE) — VARCHAR2
  • DATE_OF_BIRTH — DATE
  • DATE_OF_SIGN — DATE
  • EMAIL (MEMBER_EMAIL) — VARCHAR2