test
Tables (19)
CopyOfUntitled2
- post_number — number — Primary key — NOT NULL
- title — varchar2(100) — NOT NULL
- post_date — date — NOT NULL
- ID — varchar2(100) — Foreign key → member.ID — NOT NULL
- latitude — number — NOT NULL
- longitude — number — NOT NULL
- address — varchar2(100) — NOT NULL
CopyOfUntitled3
- commet_number — number — Primary key — NOT NULL
- content — varchar2(500) — NOT NULL
- writer — varchar2(100) — NOT NULL
- post_number — number — Foreign key → CopyOfUntitled2.post_number — NOT NULL
Untitled
- ticket_code — varchar2(100) — Primary key — NOT NULL
- ticket_name — varchar2(100) — NOT NULL
- timeLimit — number — NOT NULL
- dateLimit — number — NOT NULL
Untitled10
- file_id — bigint — Foreign key → Untitled7.file_id — NOT NULL
- report_Id — number — Foreign key → Untitled6.report_Id — NOT NULL
Untitled11
- present — id` — Primary key — NOT NULL
- give — member — NOT NULL
- take — member — NOT NULL
- ticket_code — varchar2(100) — Foreign key → Untitled.ticket_code — NOT NULL
- send — date` — NOT NULL
Untitled13
- delay_num — number — Primary key — NOT NULL
- ill — varchar2 — Foreign key → Untitled14.ill — NOT NULL
- delay_time — number
- delay_money — number
- purchase_YN — VARCHAR(255)
- Key — VARCHAR(255) — Foreign key → Untitled4.Key — NOT NULL
Untitled14
- ill — varchar2 — Primary key — NOT NULL
- active — varchar2(102341205)
- active-time — date
- ps — expire
- ticket_code — varchar2(100) — Foreign key → Untitled.ticket_code — NOT NULL
- ID — varchar2(100) — Foreign key → member.ID — NOT NULL
Untitled2
- post_num — number — Primary key — NOT NULL
- title — varchar2(100) — NOT NULL
- post_date — date — NOT NULL
- ID — varchar2(100) — Foreign key → member.ID — NOT NULL
- category — varchar2(100) — NOT NULL
Untitled3
- commet_number — number — Primary key — NOT NULL
- content — varchar2(500) — NOT NULL
- writer — varchar2(100) — NOT NULL
- post_number — number — Foreign key → Untitled2.post_num — NOT NULL
Untitled4
- Key — VARCHAR(255) — Primary key — NOT NULL
- rental — start
- return_date — date
- used-time — number
- ID — varchar2(100) — Foreign key → member.ID — NOT NULL
- bike_serial_number — number — Foreign key → bike.bike_serial_number — NOT NULL
Untitled5
- purchase_num — number — Primary key — NOT NULL
- payment_method — varchar2(10) — NOT NULL
- Payment_amount — vharchar2(100) — NOT NULL
- ticket_code — varchar2(100) — Foreign key → Untitled.ticket_code — NOT NULL
- ID — varchar2(100) — Foreign key → member.ID — NOT NULL
- purchase_date — VARCHAR(255)
- mileage_plus — number
- mileage_minus — number
Untitled6
- report_Id — number — Primary key — NOT NULL
- report_title — varchar2(20)
- report_content — varchar2(20)
- bike_serial_number — number — Foreign key → bike.bike_serial_number — NOT NULL
- ID — varchar2(100) — Foreign key → member.ID — NOT NULL
Untitled7
- file_id — bigint — Primary key — NOT NULL
- type — varchar(50) — NOT NULL
- file — name` — NOT NULL
- created_at — timestamp — NOT NULL
- ID — varchar2(100) — Foreign key → member.ID — NOT NULL
Untitled8
- file_id — bigint — Foreign key → Untitled7.file_id — NOT NULL
- noticeBoard_number — number — Foreign key → manager_board.noticeBoard_number — NOT NULL
Untitled9
- file_id — bigint — Foreign key → Untitled7.file_id — NOT NULL
- post_number — number — Foreign key → Untitled2.post_num — NOT NULL
bike
- bike_serial_number — number — Primary key — NOT NULL
- Failure — status` — NOT NULL
- place_serial_number — number — Foreign key → place.place_serial_number — NOT NULL
- enroll_date — date — NOT NULL
manager_board
- noticeBoard_number — number — Primary key — NOT NULL
- title — varchar2(100)
- post_date — date — NOT NULL
- content — varchar2(1000) — NOT NULL
member
- ID — varchar2(100) — Primary key — NOT NULL
- password — varchar2(100) — NOT NULL
- name — varchar2(100) — NOT NULL
- gender — varchar2(10) — NOT NULL
- age — number — NOT NULL
- email — varchar2(100) — NOT NULL
- address — varchar2(100)
- phone — varchar2(100) — NOT NULL
- id_enroll_date — date — NOT NULL
- member_level — varchar2(10) — NOT NULL — 관리자-일반회원 등급으로 구분
- total — mileage` — NOT NULL
- Field — VARCHAR(255)
place
- place_serial_number — number — Primary key — NOT NULL
- place_name — varchar2(100) — NOT NULL
- latitude — number — NOT NULL
- longitude — number — NOT NULL
- address — varchar2(100) — NOT NULL