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