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