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)