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)