cafeinjeju

Tables (3)

cafe_info

  • cafe_id — number — Primary key — NOT NULL
  • cafe_name — varchar2(20)

cafe_tags

  • cafe_tags (cafe_tags_id) — number — Primary key — NOT NULL
  • tag_id — varchar2(10) — Foreign key → tag_list.tag_id — NOT NULL
  • cafe_id — number — Foreign key → cafe_info.cafe_id — NOT NULL

tag_list

  • tag_id — varchar2(10) — Primary key — NOT NULL
  • tag_name — varchar2(20)