tourtour
Tables (18)
pic_comment
- cmt_uid — NUMBER — Primary key — NOT NULL
- pc_uid — NUMBER — Foreign key → picture.pc_uid — NOT NULL
- us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
- cmt_contents — VARCHAR2(100)
- cmt_date — DATE — NOT NULL
pic_lib
- pl_uid — NUMBER — Primary key — NOT NULL
- pc_uid — NUMBER — Foreign key → picture.pc_uid — NOT NULL
- pl_name — VARCHAR2(20)
- pl_type — VARCHAR2(10) — NOT NULL
- pl_size — NUMBER
- pl_path — VARCHAR2(20) — NOT NULL
pic_like
- us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
- pc_uid — NUMBER — Foreign key → picture.pc_uid — NOT NULL
- pic_like_ck — NUMBER
pic_tag
- pic_uid — NUMBER — Foreign key → picture.pc_uid — NOT NULL
- tag_uid — NUMBER — Foreign key → tag.tag_uid — NOT NULL
picture
- pc_uid — NUMBER — Primary key — NOT NULL
- us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
- pc_contents — VARCHAR2(400)
- pc_hits — NUMBER
- pc_location — NUMBER
- pc_focus — NUMBER
- pc_with — NUMBER
- pc_write_date — DATE — NOT NULL
- pc_del_ck — NUMBER
place
- place_uid — NUMBER — Primary key — NOT NULL
- contentid — NUMBER — NOT NULL
- contenttypeid — NUMBER — NOT NULL
- title — VARCHAR2(40) — NOT NULL
- mapx — FLOAT — NOT NULL
- mapy — FLOAT — NOT NULL
- areaCode — NUMBER
- sigunguCode — NUMBER
- addr1 — VARCHAR2(200)
- tel — VARCHAR2(20)
- firstimage2 — VARCHAR2(100)
- pl_viewcnt — NUMBER
place_like
- us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
- place_uid — NUMBER — Foreign key → place.place_uid — NOT NULL
- lc_like_ck — NUMBER
review
- us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
- place_uid — NUMBER — Foreign key → place.place_uid — NOT NULL
- rv_content — CLOB
- rv_rate — NUMBER
- rv_write_date — DATE — NOT NULL
tag
- tag_uid — number — Primary key — NOT NULL
- tag_name — VARCHAR2(20)
tour
- tu_uid — NUMBER — Primary key — NOT NULL
- us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
- tu_title — VARCHAR2(100) — NOT NULL
- tu_hits — NUMBER
- tu_period — NUMBER
- tu_location — NUMBER
- tu_with — NUMBER
- tu_focus — NUMBER
- tu_del_ck — NUMBER
- tu_write_date — DATE — NOT NULL
- tu_start_tour — DATE — NOT NULL
tour_day
- day_uid — NUMBER — Primary key — NOT NULL
- tu_uid — NUMBER — Foreign key → tour.tu_uid — NOT NULL
- tu_day — number — NOT NULL
tour_like
- tu_uid — NUMBER — Foreign key → tour.tu_uid — NOT NULL
- us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
- tu_like_ck — NUMBER
tour_location
- lc_uid — NUMBER — Primary key — NOT NULL
- place_uid — NUMBER — Foreign key → place.place_uid — NOT NULL
- day_uid — NUMBER — Foreign key → tour_day.day_uid — NOT NULL
- tu_uid — NUMBER — Foreign key → tour_day.tu_uid — NOT NULL
tour_memo
- memo_uid — NUMBER — Primary key — NOT NULL
- day_uid — NUMBER — Foreign key → tour_day.day_uid — NOT NULL
- tu_uid — NUMBER — Foreign key → tour_day.tu_uid — NOT NULL
- memo_contents — VARCHAR2(400)
tour_tag
- tu_uid — NUMBER — Foreign key → tour.tu_uid — NOT NULL
- tag_uid — NUMBER — Foreign key → tag.tag_uid — NOT NULL
user_authority
- us_uid — NUMBER — Foreign key → users.us_uid — NOT NULL
- us_authority — NUMBER — NOT NULL
user_log
- log_uid — NUMBER — Primary key — NOT NULL
- log_contents — VARCHAR2(40)
- log_date — DATE — NOT NULL
users
- us_uid — NUMBER — Primary key — NOT NULL
- us_id — VARCHAR2(20) — NOT NULL
- us_pw — VARCHAR2(20) — NOT NULL
- us_email — VARCHAR2(40) — NOT NULL
- us_nickName — VARCHAR2(20)
- us_gender — NUMBER
- us_birth — DATE
- us_memo — VARCHAR2(100)
- us_join_date — DATE
- us_pic — VARCHAR2(20)
- us_exit_ck — NUMBER
- us_exit_date — DATE