SUBPJT_종이비행기

테이블 (5)

Store (Untitled)

  • store_id (Key2) — Integer — 기본 키 — NOT NULL
  • store_name (Field) — varchar(50)
  • branch (Field2) — varchar(20)
  • area (Field3) — varchar(50)
  • tel (Field4) — varchar(20)
  • address (Field5) — varchar(200)
  • latitude (Field6) — real
  • longitude (Field7) — real
  • category (Field8) — varchar(200)
  • menu (Field9) — varchar(200)
  • bhour (Field10) — varchar(200)

Store_review (Untitled2)

  • review_id (Key) — Integer — 기본 키 — NOT NULL
  • store_id (Key2) — Integer — 외래 키 → Store.store_id — NOT NULL
  • user_id (Key3) — Integer — 외래 키 → User.user_id — NOT NULL
  • score (Field2) — float
  • content (Field3) — varchar(200)
  • reg_time (Field4) — datetime

TourSpot (Untitled4)

  • spot_id (Key) — Integer — 기본 키 — NOT NULL
  • addr1 (Field) — varchar2(100)
  • addr2 (Field2) — varchar2(100)
  • areacode (Field3) — Integer
  • cat1 (Field4) — varchar2(50)
  • cat2 (Field5) — varchar2(50)
  • cat3 (Field6) — varchar2(50)
  • content_id (Field7) — varchar2(50)
  • content_type_id (Field8) — varchar2(50)
  • first_image (Field10) — varchar2(100)
  • firsr_image2 (Field11) — varchar2(100)
  • mapx (Field12) — real
  • mapy (Field13) — real
  • sigungucide (Field17) — Integer
  • tel (Field18) — varchar2(50)
  • title (Field19) — varchar2(100)

Tour_review (CopyOfUntitled2)

  • review_id (Key) — Integer — 기본 키 — NOT NULL
  • user_id (Key3) — Integer — 외래 키 → User.user_id — NOT NULL
  • spot_id (Key2) — Integer — 외래 키 → TourSpot.spot_id — NOT NULL
  • score (Field2) — float
  • content (Field3) — varchar(200)
  • reg_time (Field4) — datetime

User (Untitled3)

  • user_id (Key) — Integer — 기본 키 — NOT NULL
  • email (Field) — varchar2(50)
  • pw (Field2) — varchar2(50)
  • nickname (Field5) — varchar2(50)
  • gender (Field3) — varchar2(50)
  • born_year (Field4) — Integer