에어비앤비
테이블 (10)
Accomodations (숙소)
- Key — int — 기본 키 — NOT NULL
- Field — int
- Field2 — varchar(20)
- Field3 — varcahr(200)
- Field21 — varchar(20)
- Field4 — int
- Field5 — int
- Field6 — int
- Field7 — int
- Field8 — varchar(3)
- Field9 — varchar(3)
- Field10 — varchar(3)
- Field11 — varchar(3)
- Field12 — varchar(3)
- Field13 — varchar(3)
- Field18 — int
- Field19 — int
- Field17 — text
- Field20 — decimal(1,1)
- Field14 — varchar(20)
- Field15 — timestamp
- Field16 — timestamp
Acomo_comments (후기(숙소))
- Key — int — 기본 키 — NOT NULL
- Field — int
- Field2 — int
- Field13 — int
- Field3 — int
- Field4 — int
- Field5 — int
- Field6 — int
- Field7 — int
- Field8 — int
- Field9 — varchar(4000)
- Field10 — varchar(20)
- Field11 — timestamp
- Field12 — timestamp
Acomo_files (숙소파일(사진))
- Key — int — 기본 키 — NOT NULL
- Field — int
- Field2 — varchar(200)
- Field3 — varchar(20)
- Field4 — timestamp
- Field5 — timestamp
Acomo_reservations (숙소예약)
- Key — int — 기본 키 — NOT NULL
- Field — int
- Field2 — int
- Field3 — int
- Field4 — date
- Field5 — date
- Field6 — int
- Field7 — varchar(10)
- Field8 — timestamp
- Field9 — timestamp
Acti_comments (후기(체험))
- Key — int — 기본 키 — NOT NULL
- Field — int
- Field2 — int
- Field13 — int
- Field9 — varchar(4000)
- Field10 — varchar(20)
- Field11 — timestamp
- Field12 — timestamp
Acti_reservations (체험예약)
- Key — int — 기본 키 — NOT NULL
- Field — int
- Field2 — int
- Field3 — int
- Field10 — int
- Field11 — int
- Field4 — date
- Field5 — date
- Field6 — int
- Field7 — varchar(10)
- Field8 — timestamp
- Field9 — timestamp
Activity (체험)
- Key — int — 기본 키 — NOT NULL
- Field — int
- Field2 — varchar(20)
- Field3 — varcahr(200)
- Field21 — varchar(20)
- Field4 — int
- Field5 — varchar(3)
- Field6 — varchar(3)
- Field7 — varchar(3)
- Field8 — varchar(3)
- Field9 — varchar(3)
- Field10 — varchar(3)
- Field11 — varchar(3)
- Field18 — int
- Field19 — int
- Field17 — text
- Field20 — decimal(1,1)
- Field14 — varchar(20)
- Field15 — timestamp
- Field16 — timestamp
Activity_files (CopyOf파일(사진))
- Key — int — 기본 키 — NOT NULL
- Field — int
- Field2 — varchar(200)
- Field3 — varchar(20)
- Field4 — timestamp
- Field5 — timestamp
Users (회원)
- Key — int — 기본 키 — NOT NULL
- Field — varchar(50)
- Field2 — varchar(20)
- Field3 — varchar(50)
- Field4 — date
- Field5 — varchar(20)
- Field6 — varchar(20)
- Field7 — varchar(256)
- Field8 — varchar(200)
- Field9 — varchar(10)
- Field10 — varchar(20)
- Field11 — varchar(20)
- Field12 — varchar(20)
- Field13 — varchar(3)
- Field14 — varchar(150)
- Field15 — varchar(20)
- Field16 — timestamp
- Field17 — timestamp
- Field18 — timestamp
- Field19 — varchar(3)
WishList (위시리스트)
- Key — int — 기본 키 — NOT NULL
- Field — int
- Field2 — int
- Field3 — varchar(20)
- Field4 — timestamp
- Field5 — timestamp