julseo
Tables (7)
boards
- board_id — number — Primary key — NOT NULL
- member_id — varchar2(30)
- title — varchar2(1000) — NOT NULL
- content — varchar2(2000) — NOT NULL
- create_date — varchar2(50)
- hits — number
- member_id (member_id2) — varchar2(30) — Foreign key → members.member_id — NOT NULL — 회원가입시 유저가 생성하는 아이디
comments
- comment_id — number — Primary key — NOT NULL
- member_id — varchar2(30)
- content — varchar2(2000) — NOT NULL
- create_date — varchar2(50)
- board_id (board_id2) — number — Foreign key → boards.board_id — NOT NULL
- member_id (member_id2) — varchar2(30) — Foreign key → members.member_id — NOT NULL — 회원가입시 유저가 생성하는 아이디
interested_stores
- member_id (member_id2) — varchar2(30) — Foreign key → members.member_id — NOT NULL — 회원가입시 유저가 생성하는 아이디
- store_id — number — Foreign key → stores.store_id — NOT NULL
members
- member_id — varchar2(30) — Primary key — NOT NULL — 회원가입시 유저가 생성하는 아이디
- password — varchar2(30) — NOT NULL
- nickname — varchar2(30) — NOT NULL
- phone_num — varchar2(20)
- role — number(1) — NOT NULL — role 에 따라 시스템 관리자, 점주, 일반사용자로 분류
reservations
- reservation_id — number — Primary key — NOT NULL
- people_num — number(5) — NOT NULL
- reservation_time — varchar2(30) — NOT NULL
- member_id (member_id2) — varchar2(30) — Foreign key → members.member_id — 회원가입시 유저가 생성하는 아이디
- store_name (store_name2) — varchar2(100) — Foreign key → stores.store_name — NOT NULL
reviews
- review_id — number — Primary key — NOT NULL
- content — varchar2(2000) — NOT NULL
- create_date — varchar2(50)
- taste_score — varchar2(30) — NOT NULL
- member_id (member_id2) — varchar2(30) — Foreign key → members.member_id — NOT NULL — 회원가입시 유저가 생성하는 아이디
- store_name (store_name2) — varchar2(100) — Foreign key → stores.store_name — NOT NULL
stores
- store_id — number — Primary key — NOT NULL
- store_name — varchar2(100) — Primary key — NOT NULL
- store_address — varchar2(1000) — NOT NULL
- telephone — varchar2(20)
- sit_capacity — number(5) — NOT NULL
- available_time — varchar2(50) — NOT NULL
- holiday — number
- represent_menu — varchar2(2000)
- store_img_url — varchar2(1000)
- food_category — varchar2(50) — NOT NULL
- approval_status — number — 시스템관리자에 의한 점포등록 승인여부
- member_id (member_id2) — varchar2(30) — Foreign key → members.member_id — NOT NULL — 회원가입시 유저가 생성하는 아이디