에어비앤비

테이블 (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