AlphaCar

Tables (14)

chat (Untitled)

  • chat_id — number — Primary key — NOT NULL
  • store_number — number — Foreign key → store.store_number — NOT NULL
  • customer_id — varchar2(100) — Foreign key → store.customer_id — NOT NULL

chat_log (Untitled2)

  • chat_message_id — number — Primary key — NOT NULL
  • chat_id — number — Foreign key → chat.chat_id — NOT NULL
  • store_number — number — Foreign key → store.store_number — NOT NULL
  • customer_id — varchar2(100) — Foreign key → store.customer_id — NOT NULL
  • chat_message — clob
  • readstate — boolean
  • createdate — date

customer

  • customer_id — varchar2(100) — Primary key — NOT NULL
  • customer_pw (password) — varchar2(20) — NOT NULL
  • customer_name (name) — varchar2(20) — NOT NULL
  • customer_tel (tel) — varchar2(20) — NOT NULL
  • customer_email (email) — varchar2(100) — NOT NULL
  • customer_naver (naver) — varchar2(100)
  • customer_kakao (kakao) — varchar2(100)
  • admin — varchar2(1) — NOT NULL — 고객 "C", 업주 "S", 관리자 "M"
  • nickname (nicknamen) — varchar2(20) — NOT NULL

favorite

  • fav_number — number — Primary key — NOT NULL
  • customer_id — varchar2(100) — Foreign key → customer.customer_id — NOT NULL
  • store_number — number — Foreign key → store.store_number — NOT NULL

review

  • notice_id (id) — number — Primary key — NOT NULL
  • notice_writer (customer_id) — varchar2(100) — Foreign key → customer.customer_id — NOT NULL
  • title — varchar2(300) — NOT NULL
  • notice_content (content) — varchar2(4000) — NOT NULL
  • notice_writedate (date) — date
  • notice_readcnt (readcnt) — number
  • notice_filename (filename) — varchar2(300)
  • notice_filepath (filepath) — varchar2(500)
  • store_number — number — Foreign key → store.store_number — NOT NULL

sensor

  • sensor_id — number — Primary key — NOT NULL
  • latitude — number — NOT NULL
  • longitude — number — NOT NULL

state

  • inventory_number — number — Primary key — NOT NULL
  • store_number — number — Foreign key → store.store_number — NOT NULL
  • sensor_id — number — Foreign key → sensor.sensor_id — NOT NULL
  • now_state — varchar2(1) — NOT NULL — 사용가능 할 경우 'Y', 사용 중일 경우 'n', 사용불가능할 경우 'X'
  • create_date — date — NOT NULL
  • change_date — date — NOT NULL

state_log

  • log_id (id) — number — Primary key — NOT NULL
  • inventory_number (inventory_number2) — number — Foreign key → state.inventory_number — NOT NULL
  • store_number (store_number2) — number — Foreign key → state.store_number — NOT NULL
  • sensor_id (sensor_id2) — number — Foreign key → state.sensor_id — NOT NULL
  • in_log — date
  • out_log — date

store

  • store_number — number — Primary key — NOT NULL
  • customer_id — varchar2(100) — Foreign key → customer.customer_id — NOT NULL
  • store_name — varchar2(100) — NOT NULL
  • store_addr — varchar2(100) — NOT NULL
  • store_tel — varchar2(20)
  • store_time — varchar2(100) — NOT NULL
  • store_dayoff — varchar2(100) — NOT NULL
  • store_introduce (introduce) — text — NOT NULL
  • store_inventory (inventory) — number — NOT NULL
  • store_price — varchar2(100) — NOT NULL
  • store_master_name — varchar2(100) — NOT NULL
  • store_registration_number — varchar2(100) — NOT NULL

store_file

  • store_number — number — Foreign key → store.store_number — NOT NULL
  • imgfath — varchar2(500)
  • imgname — varchar2(500)

web_best_qna (CopyOfweb_qna)

  • best_qna_id (id) — number — Primary key — NOT NULL
  • customer_id — varchar2(100) — Foreign key → customer.customer_id — NOT NULL
  • best_qna_title (title) — varchar2(300)
  • best_qna_content (content) — clob
  • best_qna_writedate (date) — date
  • best_qna_readcnt (readcnt) — number
  • best_qna_filename (filename) — varchar2(300)
  • best_qna_filepath (filepath) — varchar2(500)

web_notice

  • notice_id (id) — number — Primary key — NOT NULL
  • customer_id — varchar2(100) — Foreign key → customer.customer_id — NOT NULL
  • notice_title (title) — varchar2(300)
  • notice_content (content) — clob
  • notice_writedate (date) — date
  • notice_readcnt (readcnt) — number
  • notice_filename (filename) — varchar2(300)
  • notice_filepath (filepath) — varchar2(500)

web_notice_coment

  • notice_coment_id (id) — number — Primary key — NOT NULL
  • notice_id (id2) — number — Foreign key → web_notice.notice_id — NOT NULL
  • customer_id — varchar2(100) — Foreign key → customer.customer_id — NOT NULL
  • notice_contnent (content) — varchar2(4000)
  • writedate (date) — date

web_qna

  • qna_id (id) — number — Primary key — NOT NULL
  • customer_id — varchar2(100) — Foreign key → customer.customer_id — NOT NULL
  • qna_title (title) — varchar2(300)
  • qna_content (content) — clob
  • qna_writedate (date) — date
  • qna_readcnt (readcnt) — number
  • qna_filename (filename) — varchar2(300)
  • qna_filepath (filepath) — varchar2(500)