dd
Tables (3)
Map
- area_no — NUMBER — Primary key — NOT NULL
- area_name — VARCHAR(255)
- latitude — VARCHAR(255)
- longitude — VARCHAR(255)
Study
- study_no — VARCHAR(20) — Primary key — NOT NULL
- study_name — VARCHAR2(200)
- study_category — VARCHAR2(500)
- study_detail — VARCHAR2(2000)
- members — VARCHAR2(500)
- min_party — NUMBER
- open_date — DATETIME
- location — VARCHAR2(200)
- deadline — DATETIME
User
- id — VARCHAR(20) — Primary key — NOT NULL
- password — VARCHAR2(200)
- name — VARCHAR2(20)
- good_cnt — NUMBER — 토탈 갯수
- bad_cnt — NUMBER