Project_Neouri
Tables (10)
Alert (신고/문의)
- user_id (user id) — not null
- type1 (check type1) — check(type1 in ('A', 'Q')) not null
- title (alert title) — not null
- context (alert context) — not null
Category (관심사)
- category_seq (category sequence) — primary key — Primary key — NOT NULL
- type — not null
Category_seq (Category Sequence)
Event (이벤트)
- event_seq (event sequence) — primary key — Primary key — NOT NULL
- start_date (start timestamp) — not null
- end_date (end timestamp) — not null
- event_title (event title) — not null
- event_context (event context) — not null
- category_seq1 (category1) — not null
- category_seq2 (category2)
- category_seq3 (category3)
Event_seq (Event Sequence)
Promise (약속)
- prom_seq (promise sequence) — primary key — Primary key — NOT NULL
- prom_category (category) — not null
- prom_latitude (latitude) — not null
- prom_longitude (longitude) — not null
- start_time (start timestamp) — not null
- end_time (end timestamp) — not null
- start_age (start age) — not null
- end_age (end age) — not null
- prom_gender (gender) — check(prom_gender in ('M', 'F', 'E'))
- person_num (person count) — not null
- prom_place1 (place latitude) — not null
- prom_place2 (place longitude) — not null
- prom_context (promise context)
- event_seq (event sequence)
Promise_seq (Promise Sequence)
User (이용자)
- user_id (id) — primary key — Primary key — NOT NULL
- user_seq (sequence) — not null
- user_pw (password) — not null
- uwer_name (name) — not null
- user_age (age) — not null
- user_gender (gender) — check(user_gender in('M', 'F')) not null
- user_address1 (latitude) — not null
- user_address2 (longitude) — not null
- user_category1 (category1) — 관심사 3개까지 설정하지 않아도 됩니다
- user_category2 (category2) — 관심사 3개까지 설정하지 않아도 됩니다
- user_category3 (category3) — 관심사 3개까지 설정하지 않아도 됩니다
- user_class (class) — check(user_class in('normal', 'black', 'admin')) not null
- late — not null
- absent — not null
- no_manners (no manners) — not null