DB
Tables (8)
MATCHING (매칭)
- M_CODE (Key) — INT(10) — Primary key — NOT NULL
- M_ID (Key2) — INT(10) — Foreign key → MEMBER.M_ID — NOT NULL
- INFO (Field3) — VARCHAR(15)
- DONE (Field1) — VARCHAR(15) — NOT NULL
- S_CODE (Key3) — INT(10) — Foreign key → SURVICE.S_CODE — NOT NULL
MEMBER (회원)
- M_ID (Key) — INT(10) — Primary key — NOT NULL
- PWD (Field) — VARCHAR(15)
- RM (Field2) — VARCHAR(15)
- PHONE (Field3) — VARCHAR(15)
- ADR (Field5) — VARCHAR(50)
- CREDIT_NUM (Field6) — VARCHAR(20)
- CREDIT_EXD (Field7) — VARCHAR(20)
PAYMENT (결제)
- P_CODE(PK) (Key) — INT(10) — Primary key — NOT NULL
- M_CODE (Key3) — INT(10) — Foreign key → MATCHING.M_CODE — NOT NULL
- M_ID (Key2) — INT(10) — Foreign key → MEMBER.M_ID — NOT NULL
- CREDIT CARD (Field) — VARCHAR(10)
- BANK_TRANDFER (Field2) — VARCHAR(20)
RQ (요청서)
- RQ_CODE(PK) (Key) — INT(10) — Primary key — NOT NULL
- M_ID (Key2) — INT(10) — Foreign key → MEMBER.M_ID — NOT NULL
- TITLE (Field) — VARCHAR(10)
- CONTENT (Field2) — VARCHAR(100)
- WRITEDATE (Field3) — DATE
- HOPEDATE (Field4) — DATE
- DONE (Field5) — VARCHAR(10)
- M_CODE (Key3) — INT(10) — Foreign key → MATCHING.M_CODE — NOT NULL
SATISGACITON (만족도)
- SS_CODE(PK) (Key) — INT(10) — Primary key — NOT NULL
- SS_CONTENT (Field) — VARCHAR(100)
- WRITEDATE (Field2) — DATE
- GRADE (Field3) — VARCHAR(15)
- M_CODE (Key2) — INT(10) — Foreign key → MATCHING.M_CODE — NOT NULL
- M_ID (Key3) — INT(10) — Foreign key → MEMBER.M_ID — NOT NULL
SURVICE (서비스)
- S_CODE (Key) — INT(10) — Primary key — NOT NULL
- S_NAME (Field3) — VARCHAR(15)
- S_CONTENT (Field) — VARCHAR(150)
TUTOR (과외선생님)
- T_ID (Key) — INT(10) — Primary key — NOT NULL
- M_CODE (Key2) — INT(10) — Foreign key → MATCHING.M_CODE — NOT NULL
- PWD (Field) — VARCHAR(15)
- T_NUM (Field2) — VARCHAR(15)
- NAME (Field3) — VARCHAR(15)
- ADR (Field4) — VARCHAR(50)
- SEX (Field5) — VARCHAR(15)
- RM (Field6) — VARCHAR(10)
- PHONE (Field7) — VARCHAR(15)
- AGE (Field8) — VARCHAR(100)
T_INFO (추가정보)
- INTRO_CODE (Key) — INT(10) — Primary key — NOT NULL
- T_ID (Key2) — INT(10) — Foreign key → TUTOR.T_ID — NOT NULL
- M_CODE (Key22) — INT(10) — Foreign key → TUTOR.M_CODE — NOT NULL
- INTRO_CONTENT (Field) — VARCHAR(100)
- CAREER (Field2) — VARCHAR(1000)
- LICENSE (Field3) — VARCHAR(100)