TAXIO

Tables (4)

CAR_INFO (Untitled4)

  • C_NUMBER (차번호) — CHAR(9) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

DRIVER (Untitled2)

  • ID (면허번호) — CHAR(9) — Primary key — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR(16)
  • NAME (이름) — VARCHAR(10)
  • SEX (성별) — INT
  • EMAIL (이메일) — VARCHAR(31)
  • LICENSE (자격증 사진) — VARCHAR(100)
  • GRADE (평균별점) — FLOAT
  • Field

TRIP_INFO (Untitled3)

  • ID (탑승객ID) — VARCHAR(20) — Foreign key → USER.ID — NOT NULL
  • COUNT (여행횟수) — INT
  • REGION (지역) — CHAR(2)
  • STATE (여행상태) — INT
  • S_DATE (출발일) — DATE
  • F_DATE (도착일) — DATE

USER (Untitled)

  • ID (탑승객ID) — VARCHAR(20) — Primary key — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR(16)
  • NAME (이름) — VARCHAR(10)
  • BIRTH (생년월일) — DATE
  • CALL (연락처) — CHAR(11)
  • EMAIL (이메일) — VARCHAR(31)
  • SEX (성별) — INT
  • PARENT (보호자 연락처) — CHAR(11)