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)