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 — 회원가입시 유저가 생성하는 아이디