cafe
Tables (12)
CN_Advertising
- advertising_id — INT — Primary key — NOT NULL
- cafe_id — VARCHAR(255) — Foreign key → CN_Cafe.cafe_id — NOT NULL
- user_id — VARCHAR(30) — Foreign key → CN_User.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — CLOB
- created_date — TIMESTAMP — NOT NULL
CN_Advertising_Image
- advertising_image_id — INT — Primary key — NOT NULL
- advertising_id — INT — Foreign key → CN_Advertising.advertising_id — NOT NULL
- user_id — VARCHAR(30) — Foreign key → CN_Advertising.user_id — NOT NULL
- image_path — VARCHAR(255) — NOT NULL
CN_Bookmark
- bookmark_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(30) — Foreign key → CN_User.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — VARCHAR(255)
- likes — INT — NOT NULL
- is_public — NUMBER(1) — NOT NULL
CN_Bookmark_Cafes
- bookmark_cafes_id — INT — Primary key — NOT NULL
- bookmark_id (bookmark_id2) — INT — Foreign key → CN_Bookmark.bookmark_id — NOT NULL
- cafe_id — VARCHAR(255) — Foreign key → CN_Cafe.cafe_id — NOT NULL
CN_Bookmark_Likes
- bookmark_like_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(30) — Foreign key → CN_User.user_id — NOT NULL
- bookmark_id — INT — Foreign key → CN_Bookmark.bookmark_id — NOT NULL
CN_Cafe
- cafe_id — VARCHAR(255) — Primary key — NOT NULL
- x — VARCHAR(255) — NOT NULL
- y — VARCHAR(255) — NOT NULL
- place_name — VARCHAR(255) — NOT NULL
CN_Notice
- notice_id — INT — Primary key — NOT NULL
- user_id (user_id2) — VARCHAR(30) — Foreign key → CN_User.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — CLOB
- created_date — TIMESTAMP — NOT NULL
CN_Registered_Cafes
- registered_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(30) — Foreign key → CN_User.user_id — NOT NULL
- cafe_id — VARCHAR(255) — Foreign key → CN_Cafe.cafe_id — NOT NULL
CN_Review
- review_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(30) — Foreign key → CN_User.user_id — NOT NULL
- cafe_id — VARCHAR(255) — Foreign key → CN_Cafe.cafe_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — CLOB
- rating — INT
- likes — INT — NOT NULL
- created_date — TIMESTAMP — NOT NULL
CN_Review_Image
- review_image_id — INT — Primary key — NOT NULL
- review_id — INT — Foreign key → CN_Review.review_id — NOT NULL
- image_path — VARCHAR(255) — NOT NULL
CN_Review_Likes
- review_like_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(30) — Foreign key → CN_User.user_id — NOT NULL
- review_id — INT — Foreign key → CN_Review.review_id — NOT NULL
CN_User
- user_id — VARCHAR(30) — Primary key — NOT NULL
- user_name — VARCHAR(30)
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- user_type — VARCHAR(10) — NOT NULL
- profile_img — VARCHAR(50) — NOT NULL